Work with Field Select KE
........................................................
: Define Field Selection :
: :
: Field : OOOOOOOOOOOOOOOOOOOOOOOOOOOOOO :
: :
: And/Or . . . . . . IIII (*AND/*OR) :
: Comparison . . . . III (*EQ, *NE, *GT ...) :
: Compare to number . 3333333333.33333 :
: Compare to text . . IIIIIIIIIIIIIIIIIIIIIIIIIIIIII :
: :
: :
: F3=Exit F4=Prompt F12=Cancel :
: :
:......................................................:
|
Introduction
|
This function allows you to add new records to a database
file, and to change existing records on the file: one record at a
time.
The function may be used in either of two modes; '*ADD'
mode and '*CHANGE' mode; in '*ADD' mode you may add new records;
in '*CHANGE' mode you may change existing records. You may switch
between the two modes by means of a function key.
Key_screen
To add a new database record, you must first enter the new
'key' fields that identify the record, then press ENTER. The
function will check that the key doesn't already exist, and either
prompt you for the new record details or tell you that it
already exists.
To update a database record, you must first enter the 'key'
fields to identify the record you want. The function will then
look for your record, and either display it, or tell you that it
cannot find it.
Note that if the function already knows the key of the
record, it will automatically skip the key screen, and display the
record directly.
|
Function Keys
|
F1=Help.
|
Display related help display. By positioning the cursor at a
field on the display and pressing help, help narrative will be
displayed for that field. By placing the cursor on the title
for the display, help narrative related to the entire function
will be displayed. Once the any help narrative is displayed you
may then enlarge the display by using the F20 key or you may
display expanded help narrative by using the F2 key.
|
|
F3=Exit.
|
Exit the current task. In most cases this will return you to a
high level function without displaying all displays encountered
in getting to this point.
|
|
F4=Prompt.
|
Display a list of values available to be used in the related
field. Place your cursor on the field for which you would like
to see a list and press the F4 key.
|
|
F5=Reset.
|
Refreshes the display. In most cases the display will be
refreshed to the original values and any keyed information
typed after the last enter key will be lost.
|
|
F9=Change mode.
|
Change program entry mode to change in order to display or
update existing records.
|
|
HELP=Help.
|
Display related help display. By positioning the cursor at a
field on the display and pressing help, help narrative will be
displayed for that field. By placing the cursor on the title
for the display, help narrative related to the entire function
will be displayed. Once the any help narrative is displayed you
may then enlarge the display by using the F20 key or you may
display expanded help narrative by using the F2 key.
|
Variable Definitions
Function Keys
|
F1=Help.
|
Display related help display. By positioning the cursor at a
field on the display and pressing help, help narrative will be
displayed for that field. By placing the cursor on the title
for the display, help narrative related to the entire function
will be displayed. Once the any help narrative is displayed you
may then enlarge the display by using the F20 key or you may
display expanded help narrative by using the F2 key.
|
|
F3=Exit.
|
Exit the current task. In most cases this will return you to a
high level function without displaying all displays encountered
in getting to this point.
|
|
F4=Prompt.
|
Display a list of values available to be used in the related
field. Place your cursor on the field for which you would like
to see a list and press the F4 key.
|
|
F5=Reset.
|
Refreshes the display. In most cases the display will be
refreshed to the original values and any keyed information
typed after the last enter key will be lost.
|
|
F12=Cancel.
|
Return to previous display without performing any action.
|
|
HELP=Help.
|
Display related help display. By positioning the cursor at a
field on the display and pressing help, help narrative will be
displayed for that field. By placing the cursor on the title
for the display, help narrative related to the entire function
will be displayed. Once the any help narrative is displayed you
may then enlarge the display by using the F20 key or you may
display expanded help narrative by using the F2 key.
|
Variable Definitions
|
Internal field name
|
Display only
| | |
|
|
File Fld User Sel ID
|
Display only
| | |
|
|
And/Or
|
OPTIONAL
| | |
Enter *AND or *OR to combine two or more search criteria for the
same comparison field. Example: Brand Number *EQ 35 *OR *EQ 36
| | |
*AND = And
| | |
*BLANK = Not Assigned
| | |
*OR = Or
|
|
Comparison
|
REQUIRED
| | |
Enter the comparison you want used for record selection. Some
valid values are *EQ (equals), *GT (greater than), and *GE (greater
than or equal to).
| | |
*EQ = Equal to
| | |
*GT = Greater than
| | |
*GE = Greater than or Equal to
| | |
*LT = Less than
| | |
*LE = Less than or Equal to
| | |
*NE = Not Equal to
|
|
Compare to number
|
OPTIONAL
| | |
Enter the number you want the program to use for comparison. The
value in the file will be compared to this number, to determine
whether or not to select the record for change.
|
|
Compare to text
|
OPTIONAL
| | |
Enter the text you want used for comparison. The program will
compare the value found in the file to the value you enter here, to
decide whether to select the record. This field is case-sensitive;
be sure you enter capital and lower-case letters appropriately. If
the text contains an apostrophe (') or quotation mark ("), enter
two marks consecutively (i.e., '' or "").
|
|
|