Category : Databases and related files
Archive   : STAFF3.ZIP
Filename : STAFFHF5.STF

 
Output of file : STAFFHF5.STF contained in archive : STAFF3.ZIP
FUNCTIONS OF THE INPUT/UPDATE DATA-TABLE
========================================

NAVIGATION COMMANDS: Move the Cursor with the ARROW KEYS, , ,
, ; Go to the first Record: ;
last Record: ; Go to the first Field:
; last Field: .

RECORD NUMBER In the upper left corner of the screen you can see the
record number/total amount of records. The deleted
records are considered, as long the packing operation
(U,H,P) has yet not been executed.

ADD A RECORD: Jump to the last Record with and press
.

DELETE A RECORD: Move the cursor to the record and press .
To Undelete the record press again . The deleted
record is marked as deleted on the upper part of the
data table.

DUPLICATE RECORD: Go to the Record to be duplicated and press .
The duplicated record will be appended at the and of
the DBF file.

COPY A DATA BLOCK: Move the cursor to the first data range definition
field and press ; Move the cursor to the second
data range definition field and press ; Move the
cursor to the upper left field of the range where the
data should be copied and press .

DUPLICATE FIELD: Go to Source Field and press , Move cursor to
Target Field and press again .

REPLICATE FIELD Move the cursor to the source field and press ;
Go to the first target block definition field and press
; Go to the second target block definition
field and press ;

SEARCH FOR A STRING: Search String: + String + ; Repeat Search:
.

SEARCH & REPLACE: Move the cursor to the desired field and press ,
Type in the string to be found followed by ,
Type in the replacement string followed by < CR>.
If the replacement string is longer than the original
text the additional characters will be inserted,
If the replacement string is shorter, the resulting
text will be accommodated.

dBLOOKUP: Move the cursor to a field linked to a DBF File (marked
with an *). Press 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 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.

EDITING COMMANDS: To start Editing move the cursor to the desired Field
and start typing or press Enter . Typing directly
means to overwrite or insert new characters. Starting
with means to delete the whole content of the field
By typing the first character.

Toggle for typing over or inserting characters.
Delete Characters: ; Delete rest of Word: ;
Jump from Word to Word: .
Jump to beginning of Field: ; End of Field: .
Finish Editing with , or vertical Arrow Keys.

Cancel editing with .

CASE OPERATION: For changing the case of the characters at a field level
in one record move the cursor to the desired field and
type:

- - to change lower case in upper case.
- - to change upper case in lower case.
-
For changing the case of the characters at field level
in all the records move the cursor to the desired field
and type:

- , *, , U - to change all lower case in
upper case.
- , *, , L - to change all upper case in
lower case.
- , *, , P - to change all lower case to
initial capitals (proper).

MEMO FIELDS: To open a MEMO field press RETURN. In Fast Find or View
use the '+' key.

EXPORT A MEMO FIELD: Press when the cursor is on the MEMO field and
type the file name.

EXTERNAL TEXT FILES: Move the cursor to a character field and type:
<%\PATH\FILENAME.EXT>, . The percent sign (%)
indicates that you can access the file called
FILENAME.EXE by placing the cursor on this field and
typing . Simple data entry end editing
operations can be applied to this file. The size of
the external file which can be viewed, and operated
by this mechanism depends on the available free RAM.

HIDE A COLUMN/FIELD In order to show the information stored in distant
locations you can hide the information contained in one
or more columns/fields by moving the cursor at to
desired field and pressing . To show again the
hidden columns/fields you have to exit from the Data
Entry option and enter again.


  3 Responses to “Category : Databases and related files
Archive   : STAFF3.ZIP
Filename : STAFFHF5.STF

  1. Very nice! Thank you for this wonderful archive. I wonder why I found it only now. Long live the BBS file archives!

  2. This is so awesome! 😀 I’d be cool if you could download an entire archive of this at once, though.

  3. But one thing that puzzles me is the “mtswslnkmcjklsdlsbdmMICROSOFT” string. There is an article about it here. It is definitely worth a read: http://www.os2museum.com/wp/mtswslnk/