Standard Functions
Function Key #1 Key #2
ADD <F6>
BEGIN VALIDATE <Fl> V
CANCEL <Fl> X
CLEAR <Fl> 4
DELETE <F1> D
END VALIDATE <F1> E
EXIT <F8>
FIND NEXT <F3>
FIND PREVIOUS <Fl> <F3>
FIRSTFIELD <Fl> Up Arrow
FIRSTFORM <F1> 1
GOLD <F1>
HELP <F1> H
HOME Home
NEXT <F3>
NEXTFORM <F7>
PICTURE <Fl> P
PREVIOUS <F2>
QUERY FIRST <F2>
QUERY LAST <Fl> <F2>
REFRESH <Fl> R
RETURN <F1> V
STORE <F5>
SWITCH <F7>
UPDATE <F4>
Cursor Control Keys
Erase This key (usually defined as the control sequence ^H or the back space key) erases the last character typed and moves the cursor back one position. It should be noted that this particular key is system dependent and may be defined as some other key. The current definition for this key may be set/changed using stty(1).
Delete This key (usually defined as the key @ or the key) erases the entire field and positions the of the field. It should be noted this particular key is system dependent and may be defined as some other key. The current definition for be set/changed using stty(l).
Tab Moves the cursor to the next field.
RETURN Moves the cursor to the next field. If the current field is empty, a default value for the field will appear if such a value has been assigned.
Line Feed Moves the cursor to the next field. If the current field is empty, the contents of the same field from the last stored or deleted record will be duplicated in the current field.
Down Arrow Moves the cursor to the beginning of the next field.
Left Arrow Moves the cursor left one position without making any changes. If the cursor is at the beginning of a field, it will move to the end of the previous field.
Right Arrow Moves the cursor right one position without making any changes. If the cursor is at the end of a field, it will move to the beginning of the next field.
Up Arrow Moves the cursor to the beginning of the previous field.
Data Types
Type Explanation
boolean yes/no
char(acter) A-Z, a-z, 0-9, !#$%&*()_+~-='[]{};':",./\<>?
date MM/DD/YY, MM.DD.YY, MMDDYY
MM-DD-YY, MM/DD/YYYY, MM.DD.YYYY,
MMDDYY, MM-DD-YYYY, DD/MON/YY,
DD.MON.YY, DDMONYY, DD-MON-YY,
DD/MON/YYYY, DD.MON.YYYY,
DD-MON-YYYY.
Integer -32768 to 32767 or
long -2147483648 to 2147483647
(system-dependent);
no commas or decimal point allowed.
money Two decimal places assumed unless overridden.
real Commas, decimal places and decimal point allowed.
string Character-type field of any length (up to 32767).
time HH, HHMM, HHMMSS, HH:MM,
HH:MM:SS, HHam, HHMMam, HHMMSSam,
HH:MMam, HH:MM:SSam, HHpm, HHMMpm,
HHMMSSpm, HH:MMpm, HH:MM:SSpm