Work with Field Selections 




  *PGMMOD                   Work with Field Selections         DD/MM/YY HH:MM:SS

  Field :  OOOOOOOOOOOOOOOOOOOOOOOOOOOOOO

  Type options, press Enter.
  2=Change   4=Delete

  Opt  And/Or  Compare  Compare to
   I    OOOO     OOO    OOOOOOOOOOOOOOOOOOOOOOOOOOOOOO
   I    OOOO     OOO    OOOOOOOOOOOOOOOOOOOOOOOOOOOOOO
   I    OOOO     OOO    OOOOOOOOOOOOOOOOOOOOOOOOOOOOOO
   I    OOOO     OOO    OOOOOOOOOOOOOOOOOOOOOOOOOOOOOO
   I    OOOO     OOO    OOOOOOOOOOOOOOOOOOOOOOOOOOOOOO
   I    OOOO     OOO    OOOOOOOOOOOOOOOOOOOOOOOOOOOOOO
   I    OOOO     OOO    OOOOOOOOOOOOOOOOOOOOOOOOOOOOOO
   I    OOOO     OOO    OOOOOOOOOOOOOOOOOOOOOOOOOOOOOO
   I    OOOO     OOO    OOOOOOOOOOOOOOOOOOOOOOOOOOOOOO
   I    OOOO     OOO    OOOOOOOOOOOOOOOOOOOOOOOOOOOOOO
   I    OOOO     OOO    OOOOOOOOOOOOOOOOOOOOOOOOOOOOOO
   I    OOOO     OOO    OOOOOOOOOOOOOOOOOOOOOOOOOOOOOO
                                                                          More..

  F3=Exit   F6=Create   F12=Cancel

Introduction

This function allows you to display the records in a database file.

Positioning function

You may control which records from the file appear on the display by using the 'positioning' fields that appear on the upper part of the screen. When you enter a positioning value, the program will position the display to start with the record that you specify.

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.

F6=Create.

Create a new record.

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.

ROLLUP=Next page.

Next page.

ROLL DOWN=Previous page.

Previous page.

Line Commands

2=Change.

Change or work with the associated item.

4=Delete.

Delete the associated record.

Variable Definitions

Field :

Display only

Opt

OPTIONAL

And/Or

Display only
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

Compare

Display only
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

Display only
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 "").