home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
World of Shareware - Software Farm 2
/
wosw_2.zip
/
wosw_2
/
DATABASE
/
STAFF3.ZIP
/
STAFFHF1.STF
< prev
next >
Wrap
Text File
|
1991-07-27
|
4KB
|
74 lines
FUNCTIONS OF THE VIEW/SORT DATA-TABLE
=====================================
NAVIGATION COMMANDS: Move the Cursor with the ARROW KEYS, <PgUp>, <PgDn>,
<Home>, <End>; Go to THE first Record: <Ctrl+PgUp>;
last Record: <Ctrl+PgDn>; Go to THE first Field:
<Ctrl+Home>; last Field: <Ctrl+End>.
SEARCH FOR A STRING: Search String: <Alt+F> + String + <CR>; Repeat Search:
<Alt+N>
dBLOOKUP: Move the cursor to a field linked to a DBF File (marked
with an *). Press <F2> to invoke the dBLOOKUP
option. dBLOOKUP works only if the file has been
prepared accordingly.
A file is prepared for dBLOOKUP using the command
sequence U,R,M and entering a Y character for the field
for which a dBLOOKUP link is required. The DBF File to
be linked to each Field marked with Y must be entered.
To enter information in a file called with dBLOOKUP (F2)
press <F3> which is a toggle key for activating/desacti-
vating the edit function. This works only with the first
file called with dBLOOKUP from the main file, and in all
Data-Table modes.
MARKING RECORDS: For the situations in which the operator has to use
selection criteria not complying with any of the
logically definable search and filtering criteria, it is
possible to mark a record upon any criteria defined
during a visual observation of the information.
You mark/unmark a record by pressing the <TAB>-Key.
The marked records can be exported to a data base file
keeping the same structure as the original file.
After exporting the records into the newly defined DBF
file you have the option to delete these records.
A global marking of all the records selected by a
Viewing procedure can be achieved by pressing <Shift+
Tab>. This quick marking feature enables the massive
export and of a large number of sorted records.
The combined use of the automatic search procedure,
applied to one or more fields, with the record marking
feature can be used to fast and very specific retrieve
operations.
STATISTICS When the selected records are shown on the screen move
the cursor to the desired numeric field for which
statistics are desired. Press <Alt+F5> and wait until
the statistics are computed and displayed on the screen.
The statistics displayed are: Total, Minimum Value,
Maximum Value, Average Value, Variance, Std. Deviation.
Trying to get statistics on a character field will
result in a beep showing that this is not possible.
EXTERNAL FILES: This method is recommended for linking free text with a
DBF file, instead of using memo fields. The link has to
be done over a character field. To indicate that a link
to an external ASCII file is being defined, you have to
enter as the first character a percent sign (%), follo-
wed by the path and the file name. These external file
can be shared with other application programs.
MEMO FIELDS: To open a MEMO field press the '+' key.
DIALING: Move the cursor to a field containing a valid
telephone number and press D. For that you must
have a modem installed and have runned previously
the program INSDIAL.COM, wich comes with STAFF.