Liren Large Software Subsidy 5

home *** CD-ROM | disk | FTP | other *** search

/ Liren Large Software Subsidy 5 / 05.iso / a / a523 / 10.ddi / CHAPTER5.INP < prev next >

Wrap

Text File | 1989-12-14 | 35.7 KB | 1,556 lines

/* Copyright (c) 1988 by the Oracle Corporation */ SQL*FORMS_VERSION = 03.00.12.00.00 DEFINE FORM /* This form is used to enter, update, and query orders from customers. */ NAME = CHAPTER5 TITLE = CHAPTER3 DEFAULT_MENU_APPLICATION = DEFAULT ROOT_MENU = GROUP_NAME = MOUSE_NAVIGATION_LIMIT = VALIDATION_UNIT = FIELD DEFINE BLOCK NAME = ORDERS DESCRIPTION = ORDERS TABLE = ORD UNIQUE_KEY = OFF UPDATE_KEY = OFF IN_MENU = ON ROWS_DISPLAYED = 1 ROWS_BUFFERED = BASE_LINE = 1 LINES_PER_ROW = 0 ARRAY_SIZE = 0 COLUMN_SECURITY = OFF ORDERING = DEFINE TRIGGER NAME = KEY-CLRBLK TRIGGER_TYPE = V3 SHOW_KEY = ON DESCRIPTION = TEXT = <<< execute_trigger('clear_details'); clear_block; >>> ENDDEFINE TRIGGER DEFINE TRIGGER NAME = KEY-CLRREC TRIGGER_TYPE = V3 SHOW_KEY = ON DESCRIPTION = TEXT = <<< execute_trigger('clear_details'); clear_record; execute_trigger('query_details'); >>> ENDDEFINE TRIGGER DEFINE TRIGGER NAME = KEY-CREREC TRIGGER_TYPE = V3 SHOW_KEY = ON DESCRIPTION = TEXT = <<< execute_trigger('clear_details'); create_record; >>> ENDDEFINE TRIGGER DEFINE TRIGGER NAME = KEY-DELREC TRIGGER_TYPE = V3 SHOW_KEY = ON DESCRIPTION = TEXT = <<< declare record_count number; begin select count(*) into record_count from ITEM where ORDID = :ORDERS.ORDID; if record_count > 0 then message ('Cannot delete master record when matching detail records exist.'); raise sqlforms.form_trigger_failure; end if; end; execute_trigger('clear_details'); delete_record; execute_trigger('query_details'); >>> ENDDEFINE TRIGGER DEFINE TRIGGER NAME = KEY-DOWN TRIGGER_TYPE = V3 SHOW_KEY = ON DESCRIPTION = TEXT = <<< execute_trigger('clear_details'); down; execute_trigger('query_details'); >>> ENDDEFINE TRIGGER DEFINE TRIGGER NAME = KEY-ENTQRY TRIGGER_TYPE = V3 SHOW_KEY = ON DESCRIPTION = TEXT = <<< execute_trigger('clear_details'); enter_query; execute_trigger('query_details'); >>> ENDDEFINE TRIGGER DEFINE TRIGGER NAME = KEY-EXEQRY TRIGGER_TYPE = V3 SHOW_KEY = ON DESCRIPTION = TEXT = <<< execute_trigger('clear_details'); execute_query; execute_trigger('query_details'); >>> ENDDEFINE TRIGGER DEFINE TRIGGER NAME = KEY-NXTREC TRIGGER_TYPE = V3 SHOW_KEY = ON DESCRIPTION = TEXT = <<< execute_trigger('clear_details'); next_record; execute_trigger('query_details'); >>> ENDDEFINE TRIGGER DEFINE TRIGGER NAME = KEY-NXTSET TRIGGER_TYPE = V3 SHOW_KEY = ON DESCRIPTION = TEXT = <<< execute_trigger('clear_details'); next_set; execute_trigger('query_details'); >>> ENDDEFINE TRIGGER DEFINE TRIGGER NAME = KEY-PRVREC TRIGGER_TYPE = V3 SHOW_KEY = ON DESCRIPTION = TEXT = <<< execute_trigger('clear_details'); previous_record; execute_trigger('query_details'); >>> ENDDEFINE TRIGGER DEFINE TRIGGER NAME = KEY-SCRDOWN TRIGGER_TYPE = V3 SHOW_KEY = ON DESCRIPTION = TEXT = <<< execute_trigger('clear_details'); scroll_down; execute_trigger('query_details'); >>> ENDDEFINE TRIGGER DEFINE TRIGGER NAME = KEY-SCRUP TRIGGER_TYPE = V3 SHOW_KEY = ON DESCRIPTION = TEXT = <<< execute_trigger('clear_details'); scroll_up; execute_trigger('query_details'); >>> ENDDEFINE TRIGGER DEFINE TRIGGER NAME = KEY-UP TRIGGER_TYPE = V3 SHOW_KEY = ON DESCRIPTION = TEXT = <<< execute_trigger('clear_details'); up; execute_trigger('query_details'); >>> ENDDEFINE TRIGGER DEFINE TRIGGER NAME = clear_details TRIGGER_TYPE = V3 SHOW_KEY = ON DESCRIPTION = TEXT = <<< if :ORDERS.ORDID is not null then go_block('ITEMS'); clear_block; go_block('ORDERS'); end if; >>> ENDDEFINE TRIGGER DEFINE TRIGGER NAME = query_details TRIGGER_TYPE = V3 SHOW_KEY = ON DESCRIPTION = TEXT = <<< if :ORDERS.ORDID is not null then go_block('ITEMS'); execute_query; go_block('ORDERS'); end if; >>> ENDDEFINE TRIGGER DEFINE FIELD NAME = ORDID DATATYPE = NUMBER LENGTH = 6 DISPLAY_LENGTH = 6 QUERY_LENGTH = 6 BASE_TABLE = ON PRIMARY_KEY = OFF MANDATORY = ON DISPLAYED = ON PAGE = 1 LINE = 4 COLUMN = 20 HELP = Enter value for : ORDID LOW_VALUE = HIGH_VALUE = LOV_TEXT = LOV_TITLE = LOV_X = 0 LOV_Y = 0 INPUT_MASK = OUTPUT_MASK = EDIT_X = 0 EDIT_Y = 0 EDIT_TOP_TITLE = EDIT_BOTTOM_TITLE = EDIT_WORD_WRAP = ON DEFAULT = :SEQUENCE.ORDID.NEXTVAL ENFORCE_KEY_FROM = ECHO = ON INPUT = ON UPDATE = OFF UPDATE_NULL = OFF QUERY = ON FIXED_LENGTH = OFF AUTOSKIP = OFF AUTOHELP = OFF UPPERCASE = OFF PROMPT = PROMPT_POSITION = BESIDE PROMPT_REPEAT = OFF ENDDEFINE FIELD DEFINE FIELD NAME = ORDERDATE DATATYPE = DATE LENGTH = 9 DISPLAY_LENGTH = 9 QUERY_LENGTH = 9 BASE_TABLE = ON PRIMARY_KEY = OFF MANDATORY = OFF DISPLAYED = ON PAGE = 1 LINE = 4 COLUMN = 60 HELP = To change ORDERDATE, type a new date. LOW_VALUE = HIGH_VALUE = LOV_TEXT = LOV_TITLE = LOV_X = 0 LOV_Y = 0 INPUT_MASK = MM/DD/YY OUTPUT_MASK = MM/DD/YY EDIT_X = 0 EDIT_Y = 0 EDIT_TOP_TITLE = EDIT_BOTTOM_TITLE = EDIT_WORD_WRAP = ON DEFAULT = $$DATE$$ ENFORCE_KEY_FROM = ECHO = ON INPUT = ON UPDATE = ON UPDATE_NULL = OFF QUERY = ON FIXED_LENGTH = OFF AUTOSKIP = OFF AUTOHELP = OFF UPPERCASE = OFF PROMPT = PROMPT_POSITION = BESIDE PROMPT_REPEAT = OFF ENDDEFINE FIELD DEFINE FIELD NAME = COMMPLAN DATATYPE = CHAR LENGTH = 1 DISPLAY_LENGTH = 1 QUERY_LENGTH = 1 BASE_TABLE = ON PRIMARY_KEY = OFF MANDATORY = OFF DISPLAYED = ON PAGE = 1 LINE = 6 COLUMN = 20 HELP = Enter value for : COMMPLAN LOW_VALUE = HIGH_VALUE = LOV_TEXT = LOV_TITLE = LOV_X = 0 LOV_Y = 0 INPUT_MASK = OUTPUT_MASK = EDIT_X = 0 EDIT_Y = 0 EDIT_TOP_TITLE = EDIT_BOTTOM_TITLE = EDIT_WORD_WRAP = ON DEFAULT = ENFORCE_KEY_FROM = ECHO = ON INPUT = ON UPDATE = ON UPDATE_NULL = OFF QUERY = ON FIXED_LENGTH = OFF AUTOSKIP = OFF AUTOHELP = OFF UPPERCASE = OFF PROMPT = PROMPT_POSITION = BESIDE PROMPT_REPEAT = OFF ENDDEFINE FIELD DEFINE FIELD NAME = CUSTID DATATYPE = NUMBER LENGTH = 8 DISPLAY_LENGTH = 8 QUERY_LENGTH = 8 BASE_TABLE = ON PRIMARY_KEY = OFF MANDATORY = ON DISPLAYED = ON PAGE = 1 LINE = 6 COLUMN = 35 HELP = Press [List] to see valid CUSTID numbers. LOW_VALUE = HIGH_VALUE = LOV_TEXT = <<< SELECT NAME,CUSTID INTO :ORDERS.CUSTNAME,:ORDERS.CUSTID FROM CUSTOMER ORDER BY NAME >>> LOV_TITLE = CUSTOMER LOV_X = 20 LOV_Y = 7 INPUT_MASK = OUTPUT_MASK = EDIT_X = 0 EDIT_Y = 0 EDIT_TOP_TITLE = EDIT_BOTTOM_TITLE = EDIT_WORD_WRAP = ON DEFAULT = ENFORCE_KEY_FROM = ECHO = ON INPUT = ON UPDATE = ON UPDATE_NULL = OFF QUERY = ON FIXED_LENGTH = OFF AUTOSKIP = OFF AUTOHELP = ON UPPERCASE = OFF PROMPT = PROMPT_POSITION = BESIDE PROMPT_REPEAT = OFF ENDDEFINE FIELD DEFINE FIELD NAME = CUSTNAME DATATYPE = CHAR LENGTH = 14 DISPLAY_LENGTH = 14 QUERY_LENGTH = 14 BASE_TABLE = OFF PRIMARY_KEY = OFF MANDATORY = OFF DISPLAYED = ON PAGE = 1 LINE = 6 COLUMN = 60 HELP = LOW_VALUE = HIGH_VALUE = LOV_TEXT = LOV_TITLE = LOV_X = 0 LOV_Y = 0 INPUT_MASK = OUTPUT_MASK = EDIT_X = 0 EDIT_Y = 0 EDIT_TOP_TITLE = EDIT_BOTTOM_TITLE = EDIT_WORD_WRAP = ON DEFAULT = ENFORCE_KEY_FROM = ECHO = ON INPUT = OFF UPDATE = OFF UPDATE_NULL = OFF QUERY = OFF FIXED_LENGTH = OFF AUTOSKIP = OFF AUTOHELP = OFF UPPERCASE = OFF PROMPT = PROMPT_POSITION = BESIDE PROMPT_REPEAT = OFF ENDDEFINE FIELD DEFINE FIELD NAME = SHIPDATE DATATYPE = DATE LENGTH = 9 DISPLAY_LENGTH = 9 QUERY_LENGTH = 9 BASE_TABLE = ON PRIMARY_KEY = OFF MANDATORY = OFF DISPLAYED = ON PAGE = 1 LINE = 8 COLUMN = 20 HELP = Enter value for : SHIPDATE LOW_VALUE = HIGH_VALUE = LOV_TEXT = LOV_TITLE = LOV_X = 0 LOV_Y = 0 INPUT_MASK = OUTPUT_MASK = EDIT_X = 0 EDIT_Y = 0 EDIT_TOP_TITLE = EDIT_BOTTOM_TITLE = EDIT_WORD_WRAP = ON DEFAULT = ENFORCE_KEY_FROM = ECHO = ON INPUT = ON UPDATE = ON UPDATE_NULL = OFF QUERY = ON FIXED_LENGTH = OFF AUTOSKIP = OFF AUTOHELP = OFF UPPERCASE = OFF PROMPT = PROMPT_POSITION = BESIDE PROMPT_REPEAT = OFF ENDDEFINE FIELD DEFINE FIELD NAME = TOTAL DATATYPE = NUMBER LENGTH = 10 DISPLAY_LENGTH = 8 QUERY_LENGTH = 10 BASE_TABLE = ON PRIMARY_KEY = OFF MANDATORY = OFF DISPLAYED = ON PAGE = 1 LINE = 8 COLUMN = 60 HELP = Enter value for : TOTAL LOW_VALUE = HIGH_VALUE = LOV_TEXT = LOV_TITLE = LOV_X = 0 LOV_Y = 0 INPUT_MASK = $99999.99 OUTPUT_MASK = $99999.99 EDIT_X = 0 EDIT_Y = 0 EDIT_TOP_TITLE = EDIT_BOTTOM_TITLE = EDIT_WORD_WRAP = ON DEFAULT = ENFORCE_KEY_FROM = ECHO = ON INPUT = ON UPDATE = ON UPDATE_NULL = OFF QUERY = ON FIXED_LENGTH = OFF AUTOSKIP = OFF AUTOHELP = OFF UPPERCASE = OFF PROMPT = PROMPT_POSITION = BESIDE PROMPT_REPEAT = OFF ENDDEFINE FIELD ENDDEFINE BLOCK DEFINE BLOCK NAME = ITEMS DESCRIPTION = ITEMS TABLE = ITEM UNIQUE_KEY = OFF UPDATE_KEY = OFF IN_MENU = ON ROWS_DISPLAYED = 4 ROWS_BUFFERED = 20 BASE_LINE = 14 LINES_PER_ROW = 1 ARRAY_SIZE = 10 COLUMN_SECURITY = OFF ORDERING = <<< ORDER BY ITEMID >>> DEFINE FIELD NAME = ORDID DATATYPE = NUMBER LENGTH = 6 DISPLAY_LENGTH = 1 QUERY_LENGTH = 6 BASE_TABLE = ON PRIMARY_KEY = OFF MANDATORY = ON DISPLAYED = OFF PAGE = 1 LINE = 1 COLUMN = 80 HELP = LOW_VALUE = HIGH_VALUE = LOV_TEXT = LOV_TITLE = LOV_X = 0 LOV_Y = 0 INPUT_MASK = OUTPUT_MASK = EDIT_X = 0 EDIT_Y = 0 EDIT_TOP_TITLE = EDIT_BOTTOM_TITLE = EDIT_WORD_WRAP = ON DEFAULT = ENFORCE_KEY_FROM = ORDERS.ORDID ECHO = ON INPUT = OFF UPDATE = OFF UPDATE_NULL = OFF QUERY = OFF FIXED_LENGTH = OFF AUTOSKIP = OFF AUTOHELP = OFF UPPERCASE = OFF PROMPT = PROMPT_POSITION = BESIDE PROMPT_REPEAT = OFF ENDDEFINE FIELD DEFINE FIELD NAME = ITEMID DATATYPE = NUMBER LENGTH = 6 DISPLAY_LENGTH = 4 QUERY_LENGTH = 6 BASE_TABLE = ON PRIMARY_KEY = OFF MANDATORY = ON DISPLAYED = ON PAGE = 1 LINE = 1 COLUMN = 4 HELP = Enter value for : ITEMID LOW_VALUE = HIGH_VALUE = LOV_TEXT = LOV_TITLE = LOV_X = 0 LOV_Y = 0 INPUT_MASK = OUTPUT_MASK = EDIT_X = 0 EDIT_Y = 0 EDIT_TOP_TITLE = EDIT_BOTTOM_TITLE = EDIT_WORD_WRAP = ON DEFAULT = ENFORCE_KEY_FROM = ECHO = ON INPUT = ON UPDATE = ON UPDATE_NULL = OFF QUERY = ON FIXED_LENGTH = OFF AUTOSKIP = OFF AUTOHELP = OFF UPPERCASE = OFF PROMPT = PROMPT_POSITION = ABOVE PROMPT_REPEAT = OFF ENDDEFINE FIELD DEFINE FIELD NAME = PRODID DATATYPE = INT LENGTH = 6 DISPLAY_LENGTH = 6 QUERY_LENGTH = 8 BASE_TABLE = ON PRIMARY_KEY = OFF MANDATORY = OFF DISPLAYED = ON PAGE = 1 LINE = 1 COLUMN = 10 HELP = Enter value for : PRODID LOW_VALUE = HIGH_VALUE = LOV_TEXT = LOV_TITLE = LOV_X = 0 LOV_Y = 0 INPUT_MASK = OUTPUT_MASK = EDIT_X = 0 EDIT_Y = 0 EDIT_TOP_TITLE = EDIT_BOTTOM_TITLE = EDIT_WORD_WRAP = ON DEFAULT = ENFORCE_KEY_FROM = ECHO = ON INPUT = ON UPDATE = ON UPDATE_NULL = OFF QUERY = ON FIXED_LENGTH = OFF AUTOSKIP = OFF AUTOHELP = OFF UPPERCASE = OFF PROMPT = PROMPT_POSITION = ABOVE PROMPT_REPEAT = OFF ENDDEFINE FIELD DEFINE FIELD NAME = PRODUCTDESCRIPTION DATATYPE = CHAR LENGTH = 23 DISPLAY_LENGTH = 23 QUERY_LENGTH = 23 BASE_TABLE = OFF PRIMARY_KEY = OFF MANDATORY = OFF DISPLAYED = ON PAGE = 1 LINE = 1 COLUMN = 18 HELP = LOW_VALUE = HIGH_VALUE = LOV_TEXT = LOV_TITLE = LOV_X = 0 LOV_Y = 0 INPUT_MASK = OUTPUT_MASK = EDIT_X = 0 EDIT_Y = 0 EDIT_TOP_TITLE = EDIT_BOTTOM_TITLE = EDIT_WORD_WRAP = ON DEFAULT = ENFORCE_KEY_FROM = ECHO = ON INPUT = OFF UPDATE = OFF UPDATE_NULL = OFF QUERY = OFF FIXED_LENGTH = OFF AUTOSKIP = OFF AUTOHELP = OFF UPPERCASE = OFF PROMPT = PROMPT_POSITION = BESIDE PROMPT_REPEAT = OFF ENDDEFINE FIELD DEFINE FIELD NAME = STDPRICE DATATYPE = NUMBER LENGTH = 8 DISPLAY_LENGTH = 8 QUERY_LENGTH = 8 BASE_TABLE = OFF PRIMARY_KEY = OFF MANDATORY = OFF DISPLAYED = ON PAGE = 1 LINE = 1 COLUMN = 43 HELP = LOW_VALUE = HIGH_VALUE = LOV_TEXT = LOV_TITLE = LOV_X = 0 LOV_Y = 0 INPUT_MASK = OUTPUT_MASK = EDIT_X = 0 EDIT_Y = 0 EDIT_TOP_TITLE = EDIT_BOTTOM_TITLE = EDIT_WORD_WRAP = ON DEFAULT = ENFORCE_KEY_FROM = ECHO = ON INPUT = OFF UPDATE = OFF UPDATE_NULL = OFF QUERY = OFF FIXED_LENGTH = OFF AUTOSKIP = OFF AUTOHELP = OFF UPPERCASE = OFF PROMPT = PROMPT_POSITION = BESIDE PROMPT_REPEAT = OFF ENDDEFINE FIELD DEFINE FIELD NAME = ACTUALPRICE DATATYPE = NUMBER LENGTH = 8 DISPLAY_LENGTH = 8 QUERY_LENGTH = 10 BASE_TABLE = ON PRIMARY_KEY = OFF MANDATORY = OFF DISPLAYED = ON PAGE = 1 LINE = 1 COLUMN = 53 HELP = Enter value for : ACTUALPRICE LOW_VALUE = HIGH_VALUE = LOV_TEXT = LOV_TITLE = LOV_X = 0 LOV_Y = 0 INPUT_MASK = $999.99 OUTPUT_MASK = $999.99 EDIT_X = 0 EDIT_Y = 0 EDIT_TOP_TITLE = EDIT_BOTTOM_TITLE = EDIT_WORD_WRAP = ON DEFAULT = ENFORCE_KEY_FROM = ECHO = ON INPUT = ON UPDATE = ON UPDATE_NULL = OFF QUERY = ON FIXED_LENGTH = OFF AUTOSKIP = OFF AUTOHELP = OFF UPPERCASE = OFF PROMPT = PROMPT_POSITION = ABOVE PROMPT_REPEAT = OFF ENDDEFINE FIELD DEFINE FIELD NAME = QTY DATATYPE = NUMBER LENGTH = 5 DISPLAY_LENGTH = 5 QUERY_LENGTH = 10 BASE_TABLE = ON PRIMARY_KEY = OFF MANDATORY = OFF DISPLAYED = ON PAGE = 1 LINE = 1 COLUMN = 63 HELP = Enter value for : QTY LOW_VALUE = HIGH_VALUE = LOV_TEXT = LOV_TITLE = LOV_X = 0 LOV_Y = 0 INPUT_MASK = OUTPUT_MASK = EDIT_X = 0 EDIT_Y = 0 EDIT_TOP_TITLE = EDIT_BOTTOM_TITLE = EDIT_WORD_WRAP = ON DEFAULT = ENFORCE_KEY_FROM = ECHO = ON INPUT = ON UPDATE = ON UPDATE_NULL = OFF QUERY = ON FIXED_LENGTH = OFF AUTOSKIP = OFF AUTOHELP = OFF UPPERCASE = OFF PROMPT = PROMPT_POSITION = ABOVE PROMPT_REPEAT = OFF ENDDEFINE FIELD DEFINE FIELD NAME = ITEMTOT DATATYPE = NUMBER LENGTH = 11 DISPLAY_LENGTH = 8 QUERY_LENGTH = 11 BASE_TABLE = ON PRIMARY_KEY = OFF MANDATORY = OFF DISPLAYED = ON PAGE = 1 LINE = 1 COLUMN = 70 HELP = Enter value for : ITEMTOT LOW_VALUE = HIGH_VALUE = LOV_TEXT = LOV_TITLE = LOV_X = 0 LOV_Y = 0 INPUT_MASK = $999999.99 OUTPUT_MASK = $999999.99 EDIT_X = 0 EDIT_Y = 0 EDIT_TOP_TITLE = EDIT_BOTTOM_TITLE = EDIT_WORD_WRAP = ON DEFAULT = ENFORCE_KEY_FROM = ECHO = ON INPUT = OFF UPDATE = OFF UPDATE_NULL = OFF QUERY = OFF FIXED_LENGTH = OFF AUTOSKIP = OFF AUTOHELP = OFF UPPERCASE = OFF PROMPT = PROMPT_POSITION = ABOVE PROMPT_REPEAT = OFF ENDDEFINE FIELD ENDDEFINE BLOCK DEFINE BLOCK NAME = CUSTOMERS DESCRIPTION = CUSTOMERS TABLE = CUSTOMER UNIQUE_KEY = OFF UPDATE_KEY = OFF IN_MENU = ON ROWS_DISPLAYED = 1 ROWS_BUFFERED = BASE_LINE = 1 LINES_PER_ROW = 0 ARRAY_SIZE = 0 COLUMN_SECURITY = OFF ORDERING = DEFINE FIELD NAME = CUSTID DATATYPE = NUMBER LENGTH = 8 DISPLAY_LENGTH = 8 QUERY_LENGTH = 8 BASE_TABLE = ON PRIMARY_KEY = OFF MANDATORY = ON DISPLAYED = ON PAGE = 2 LINE = 4 COLUMN = 20 HELP = Enter value for : CUSTID LOW_VALUE = HIGH_VALUE = LOV_TEXT = LOV_TITLE = LOV_X = 0 LOV_Y = 0 INPUT_MASK = OUTPUT_MASK = EDIT_X = 0 EDIT_Y = 0 EDIT_TOP_TITLE = EDIT_BOTTOM_TITLE = EDIT_WORD_WRAP = ON DEFAULT = ENFORCE_KEY_FROM = ECHO = ON INPUT = ON UPDATE = ON UPDATE_NULL = OFF QUERY = ON FIXED_LENGTH = OFF AUTOSKIP = OFF AUTOHELP = OFF UPPERCASE = OFF PROMPT = CUSTID PROMPT_POSITION = BESIDE PROMPT_REPEAT = OFF ENDDEFINE FIELD DEFINE FIELD NAME = NAME DATATYPE = CHAR LENGTH = 45 DISPLAY_LENGTH = 45 QUERY_LENGTH = 45 BASE_TABLE = ON PRIMARY_KEY = OFF MANDATORY = OFF DISPLAYED = ON PAGE = 2 LINE = 6 COLUMN = 20 HELP = Enter value for : NAME LOW_VALUE = HIGH_VALUE = LOV_TEXT = LOV_TITLE = LOV_X = 0 LOV_Y = 0 INPUT_MASK = OUTPUT_MASK = EDIT_X = 0 EDIT_Y = 0 EDIT_TOP_TITLE = EDIT_BOTTOM_TITLE = EDIT_WORD_WRAP = ON DEFAULT = ENFORCE_KEY_FROM = ECHO = ON INPUT = ON UPDATE = ON UPDATE_NULL = OFF QUERY = ON FIXED_LENGTH = OFF AUTOSKIP = OFF AUTOHELP = OFF UPPERCASE = OFF PROMPT = NAME PROMPT_POSITION = BESIDE PROMPT_REPEAT = OFF ENDDEFINE FIELD DEFINE FIELD NAME = ADDRESS DATATYPE = CHAR LENGTH = 40 DISPLAY_LENGTH = 40 QUERY_LENGTH = 40 BASE_TABLE = ON PRIMARY_KEY = OFF MANDATORY = OFF DISPLAYED = ON PAGE = 2 LINE = 8 COLUMN = 20 HELP = Enter value for : ADDRESS LOW_VALUE = HIGH_VALUE = LOV_TEXT = LOV_TITLE = LOV_X = 0 LOV_Y = 0 INPUT_MASK = OUTPUT_MASK = EDIT_X = 0 EDIT_Y = 0 EDIT_TOP_TITLE = EDIT_BOTTOM_TITLE = EDIT_WORD_WRAP = ON DEFAULT = ENFORCE_KEY_FROM = ECHO = ON INPUT = ON UPDATE = ON UPDATE_NULL = OFF QUERY = ON FIXED_LENGTH = OFF AUTOSKIP = OFF AUTOHELP = OFF UPPERCASE = OFF PROMPT = ADDRESS PROMPT_POSITION = BESIDE PROMPT_REPEAT = OFF ENDDEFINE FIELD DEFINE FIELD NAME = CITY DATATYPE = CHAR LENGTH = 30 DISPLAY_LENGTH = 30 QUERY_LENGTH = 30 BASE_TABLE = ON PRIMARY_KEY = OFF MANDATORY = OFF DISPLAYED = ON PAGE = 2 LINE = 10 COLUMN = 20 HELP = Enter value for : CITY LOW_VALUE = HIGH_VALUE = LOV_TEXT = LOV_TITLE = LOV_X = 0 LOV_Y = 0 INPUT_MASK = OUTPUT_MASK = EDIT_X = 0 EDIT_Y = 0 EDIT_TOP_TITLE = EDIT_BOTTOM_TITLE = EDIT_WORD_WRAP = ON DEFAULT = ENFORCE_KEY_FROM = ECHO = ON INPUT = ON UPDATE = ON UPDATE_NULL = OFF QUERY = ON FIXED_LENGTH = OFF AUTOSKIP = OFF AUTOHELP = OFF UPPERCASE = OFF PROMPT = CITY PROMPT_POSITION = BESIDE PROMPT_REPEAT = OFF ENDDEFINE FIELD DEFINE FIELD NAME = STATE DATATYPE = CHAR LENGTH = 2 DISPLAY_LENGTH = 2 QUERY_LENGTH = 2 BASE_TABLE = ON PRIMARY_KEY = OFF MANDATORY = OFF DISPLAYED = ON PAGE = 2 LINE = 12 COLUMN = 20 HELP = To changee value of STATE, type new entry over CA. LOW_VALUE = HIGH_VALUE = LOV_TEXT = LOV_TITLE = LOV_X = 0 LOV_Y = 0 INPUT_MASK = OUTPUT_MASK = EDIT_X = 0 EDIT_Y = 0 EDIT_TOP_TITLE = EDIT_BOTTOM_TITLE = EDIT_WORD_WRAP = ON DEFAULT = CA ENFORCE_KEY_FROM = ECHO = ON INPUT = ON UPDATE = ON UPDATE_NULL = OFF QUERY = ON FIXED_LENGTH = ON AUTOSKIP = ON AUTOHELP = OFF UPPERCASE = ON PROMPT = STATE PROMPT_POSITION = BESIDE PROMPT_REPEAT = OFF ENDDEFINE FIELD DEFINE FIELD NAME = ZIP DATATYPE = CHAR LENGTH = 9 DISPLAY_LENGTH = 9 QUERY_LENGTH = 9 BASE_TABLE = ON PRIMARY_KEY = OFF MANDATORY = OFF DISPLAYED = ON PAGE = 2 LINE = 12 COLUMN = 60 HELP = Enter value for : ZIP LOW_VALUE = HIGH_VALUE = LOV_TEXT = LOV_TITLE = LOV_X = 0 LOV_Y = 0 INPUT_MASK = OUTPUT_MASK = EDIT_X = 0 EDIT_Y = 0 EDIT_TOP_TITLE = EDIT_BOTTOM_TITLE = EDIT_WORD_WRAP = ON DEFAULT = ENFORCE_KEY_FROM = ECHO = ON INPUT = ON UPDATE = ON UPDATE_NULL = OFF QUERY = ON FIXED_LENGTH = OFF AUTOSKIP = OFF AUTOHELP = OFF UPPERCASE = OFF PROMPT = ZIP PROMPT_POSITION = BESIDE PROMPT_REPEAT = OFF ENDDEFINE FIELD DEFINE FIELD NAME = AREA DATATYPE = NUMBER LENGTH = 5 DISPLAY_LENGTH = 5 QUERY_LENGTH = 5 BASE_TABLE = ON PRIMARY_KEY = OFF MANDATORY = OFF DISPLAYED = ON PAGE = 2 LINE = 14 COLUMN = 20 HELP = Enter value for : AREA LOW_VALUE = HIGH_VALUE = LOV_TEXT = LOV_TITLE = LOV_X = 0 LOV_Y = 0 INPUT_MASK = OUTPUT_MASK = EDIT_X = 0 EDIT_Y = 0 EDIT_TOP_TITLE = EDIT_BOTTOM_TITLE = EDIT_WORD_WRAP = ON DEFAULT = ENFORCE_KEY_FROM = ECHO = ON INPUT = ON UPDATE = ON UPDATE_NULL = OFF QUERY = ON FIXED_LENGTH = OFF AUTOSKIP = OFF AUTOHELP = OFF UPPERCASE = OFF PROMPT = AREA PROMPT_POSITION = BESIDE PROMPT_REPEAT = OFF ENDDEFINE FIELD DEFINE FIELD NAME = PHONE DATATYPE = CHAR LENGTH = 9 DISPLAY_LENGTH = 9 QUERY_LENGTH = 9 BASE_TABLE = ON PRIMARY_KEY = OFF MANDATORY = OFF DISPLAYED = ON PAGE = 2 LINE = 14 COLUMN = 60 HELP = Enter value for : PHONE LOW_VALUE = HIGH_VALUE = LOV_TEXT = LOV_TITLE = LOV_X = 0 LOV_Y = 0 INPUT_MASK = OUTPUT_MASK = EDIT_X = 0 EDIT_Y = 0 EDIT_TOP_TITLE = EDIT_BOTTOM_TITLE = EDIT_WORD_WRAP = ON DEFAULT = ENFORCE_KEY_FROM = ECHO = ON INPUT = ON UPDATE = ON UPDATE_NULL = OFF QUERY = ON FIXED_LENGTH = OFF AUTOSKIP = OFF AUTOHELP = OFF UPPERCASE = OFF PROMPT = PHONE PROMPT_POSITION = BESIDE PROMPT_REPEAT = OFF ENDDEFINE FIELD DEFINE FIELD NAME = REPID DATATYPE = NUMBER LENGTH = 6 DISPLAY_LENGTH = 6 QUERY_LENGTH = 6 BASE_TABLE = ON PRIMARY_KEY = OFF MANDATORY = ON DISPLAYED = ON PAGE = 2 LINE = 16 COLUMN = 20 HELP = Enter value for : REPID LOW_VALUE = HIGH_VALUE = LOV_TEXT = LOV_TITLE = LOV_X = 0 LOV_Y = 0 INPUT_MASK = OUTPUT_MASK = EDIT_X = 0 EDIT_Y = 0 EDIT_TOP_TITLE = EDIT_BOTTOM_TITLE = EDIT_WORD_WRAP = ON DEFAULT = ENFORCE_KEY_FROM = ECHO = ON INPUT = ON UPDATE = ON UPDATE_NULL = OFF QUERY = ON FIXED_LENGTH = OFF AUTOSKIP = OFF AUTOHELP = OFF UPPERCASE = OFF PROMPT = REPID PROMPT_POSITION = BESIDE PROMPT_REPEAT = OFF ENDDEFINE FIELD DEFINE FIELD NAME = CREDITLIMIT DATATYPE = NUMBER LENGTH = 11 DISPLAY_LENGTH = 11 QUERY_LENGTH = 11 BASE_TABLE = ON PRIMARY_KEY = OFF MANDATORY = OFF DISPLAYED = ON PAGE = 2 LINE = 16 COLUMN = 60 HELP = Enter value for : CREDITLIMIT LOW_VALUE = 1000 HIGH_VALUE = 20000 LOV_TEXT = LOV_TITLE = LOV_X = 0 LOV_Y = 0 INPUT_MASK = OUTPUT_MASK = EDIT_X = 0 EDIT_Y = 0 EDIT_TOP_TITLE = EDIT_BOTTOM_TITLE = EDIT_WORD_WRAP = ON DEFAULT = ENFORCE_KEY_FROM = ECHO = ON INPUT = ON UPDATE = ON UPDATE_NULL = OFF QUERY = ON FIXED_LENGTH = OFF AUTOSKIP = OFF AUTOHELP = OFF UPPERCASE = OFF PROMPT = CREDITLIMIT PROMPT_POSITION = BESIDE PROMPT_REPEAT = OFF ENDDEFINE FIELD DEFINE FIELD NAME = COMMENTS DATATYPE = LONG LENGTH = 240 DISPLAY_LENGTH = 60 QUERY_LENGTH = 0 BASE_TABLE = ON PRIMARY_KEY = OFF MANDATORY = OFF DISPLAYED = ON PAGE = 2 LINE = 18 COLUMN = 20 HELP = Enter value for : COMMENTS LOW_VALUE = HIGH_VALUE = LOV_TEXT = LOV_TITLE = LOV_X = 0 LOV_Y = 0 INPUT_MASK = OUTPUT_MASK = EDIT_X = 0 EDIT_Y = 0 EDIT_TOP_TITLE = EDIT_BOTTOM_TITLE = EDIT_WORD_WRAP = ON DEFAULT = ENFORCE_KEY_FROM = ECHO = ON INPUT = ON UPDATE = ON UPDATE_NULL = OFF QUERY = OFF FIXED_LENGTH = OFF AUTOSKIP = OFF AUTOHELP = OFF UPPERCASE = OFF PROMPT = COMMENTS PROMPT_POSITION = BESIDE PROMPT_REPEAT = OFF ENDDEFINE FIELD ENDDEFINE BLOCK DEFINE SCREEN DEFINE PAGE PAGE = 1 POPUP = OFF BORDER = OFF HORIZONTAL_SCROLL_BAR = OFF VERTICAL_SCROLL_BAR = OFF DISSOLVE = OFF TITLE = PAGE_XS = 0 PAGE_YS = 0 PAGE_PX0 = 0 PAGE_PY0 = 0 PAGE_PXS = 0 PAGE_PYS = 0 PAGE_SX0 = 0 PAGE_SY0 = 0 MODE = TEXT BOILER = <<< SUMMIT SPORTING GOODS ======== ORDERS ======== >>> LINE = 4 BOILER = <<< ORDID ORDERDATE >>> LINE = 6 BOILER = <<< COMMPLAN CUSTID CUSTNAME >>> LINE = 8 BOILER = <<< SHIPDATE TOTAL >>> LINE = 10 BOILER = <<< ======== ITEMS ======== >>> LINE = 12 BOILER = <<< ITEM PROD PRODUCT STD ACTUAL QTY ITEMTOT ID ID DESCRIPTION PRICE PRICE >>> MODE = BOX LINE = 3 BOILER = <<< p-----------------------------------------------------------------q | | | | | | | | | | b-----------------------------------------------------------------d >>> ENDDEFINE PAGE DEFINE PAGE PAGE = 2 POPUP = ON BORDER = ON HORIZONTAL_SCROLL_BAR = OFF VERTICAL_SCROLL_BAR = ON DISSOLVE = ON TITLE = PAGE_XS = 80 PAGE_YS = 18 PAGE_PX0 = 6 PAGE_PY0 = 3 PAGE_PXS = 70 PAGE_PYS = 14 PAGE_SX0 = 5 PAGE_SY0 = 2 MODE = TEXT LINE = 2 BOILER = <<< ======== CUSTOMERS ======== >>> ENDDEFINE PAGE ENDDEFINE SCREEN ENDDEFINE FORM