" BGCOLOR="#FFFFFF" TEXT="#000000" LINK="#008000" VLINK="004000" ALINK="#00C000">
VIEWING DATABASES
When viewing database files it is convenient to use the BASEVIEW.COM
program supplied on the CP distribution diskette. Like the ARCHVIEW.COM
program it works only within the CP shell and cannot be run independently.
You can make CP call this program by pressing [F3]. Please bear in
mind that the CP also provides an option to edit databases (for more
information see "VIEWING AND EDITING DATABASES").
To load the database viewing program automatically add CPVIEW.EXT file
to the CP directory (for more information see "Extension files") The
layout of the BASEVIEW program screen in the mode of viewing its records is
given below:
+---------------- Database view ------------------6:32pm--+
| Record: 8 ( 0%) B Database: SHOPS.DBF Lower=Upper |
|-------------+-------------------------------------------+
|N | 1 |
|ADDR |Tverskaya 41 |
|TEL |250-5052 |
| |250-6607 |
| | |
| | |
| | |
| | |
|-------------+-------------------------------------------|
| <F1> - Help. (C) PhysTech Soft Ltd. 1991-1996. |
+-------------------------------------------------[290K]--+
The BASEVIEW program allows you to view files in two modes: the mode
of viewing a record and the mode of viewing records in a tabular form. The
layout of the BASEVIEW program screen in the mode of viewing records in a
tabular form looks like follows:
+------------------ Database view ------- 6 34pm -+
|Record: 44 (97%) B Database: SHOPS.DBF Lower=Upper|
+---------------------------------------------------------+
|N ADDR TEL |
|+++++++++++++++++++++++++++++++++++++++++++++++++++++++++|
| 49 Tverskaya 34 144-5430 144-5455 |
| |
| |
| |
| |
| |
+---------------------------------------------------------+
| <F1> - Help. (+) PhysTechSoft Ltd.1991-1996 |
+---------------------------------------- +++ --- [468k] -+
The pull-down menu is displayed as the top line of the screen and
contains three items:
- "Movement",
- "Search",
- "Other".
The pull-down menu for database viewing may be invoked performing
one of the following operations:
1) Press the key [F9].
2) Place the mouse cursor onto the top line of the screen and press the
mouse left button.
Moving around in a file
The "movement" submenu contains the following options:
First record [Ctrl-PgUp] - move to the first record.
Last record [Ctrl-PgDn] - move to the last record.
Next record [PgDn] - move to the next record.
Previous record [PgUp] - move to the previous record
Go to record [F5] - go to the record with specified
number
go to Percent of file [Ctrl-F5] - go to the specified file percentage
Store position [F6] - mark one position in the file
Restore position [Shift-F6] - go to marked position
Moving through the file in the mode of viewing a record
Using the keys [up arrow], [down arrow] you may scroll through all
the fields on the screen. To position a field as the top line of the
screen place the mouse cursor onto that field and press the left button.
To view long lines you should perform one of the following operations:
1) Use the keys [right arrow], [left arrow].
2) Place the mouse cursor onto the vertical boundary lines of the screen
and press the left button.
Besides this, it is possible to go to the specified line, position, or
file percentage. These features are similar to those of CP's editor.
Moving through the file in the tabular viewing mode
Moving through the file in the tabular viewing mode differs to some
extent from the movement in the mode of viewing a record. Using the keys
[left arrow], [right arrow] you can scroll through all the fields on the
screen and using the keys [up arrow], [down arrow] you can browse through
all the records. Using the keys [PgUp] and [PgDn] you can shift the file 19
records up or down respectively. The function keys to mark and go to the
position in the file are identical in both the tabular and the record
viewing modes.
Searching
When viewing data bases the search commands are identical to those
relevant to CP's edit feature.
Other utilities
The "Other" menu contains the following items:
Quit [Esc] - quit the viewing program
(To perform this you can also
press the mouse right button.)
Help [F1]
Database info [Shift-F1] - invoke the database information
feature
The program pops up information on the database that includes the
database type, the date of the last update, the number of fields, the
number of records.
Field info [Ctrl-F1] - invoke the field information
feature
The program pops up information on the database that includes the name
of the field, the type of the field, the length of the field.
Tabular/record mode [F2] - toggle between tabular and record
modes
Kbd buffer on/off [Shift-F4] - turn the keyboard buffer ON/OFF.