Liren Large Software Subsidy 5

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

/ Liren Large Software Subsidy 5 / 05.iso / a / a522 / 32.ddi / CHAPTER3.INP next >

Wrap

Text File | 1989-12-14 | 31.1 KB | 1,386 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 = CHAPTER3 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 = ENFORCE_KEY_FROM = ECHO = ON INPUT = ON UPDATE = OFF UPDATE_NULL = OFF QUERY = ON FIXED_LENGTH = OFF AUTOSKIP = OFF AUTOHELP = OFF UPPERCASE = OFF PROMPT = ORDID 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 = Enter value for : ORDERDATE 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 = ORDERDATE 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 = COMMPLAN 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 = 60 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 = 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 = SHIPDATE PROMPT_POSITION = BESIDE PROMPT_REPEAT = OFF ENDDEFINE FIELD DEFINE FIELD NAME = TOTAL DATATYPE = NUMBER LENGTH = 10 DISPLAY_LENGTH = 10 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 = 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 = TOTAL 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 = BASE_LINE = 13 LINES_PER_ROW = 1 ARRAY_SIZE = 0 COLUMN_SECURITY = OFF ORDERING = DEFINE FIELD NAME = ITEMID DATATYPE = NUMBER LENGTH = 6 DISPLAY_LENGTH = 6 QUERY_LENGTH = 6 BASE_TABLE = ON PRIMARY_KEY = OFF MANDATORY = ON DISPLAYED = ON PAGE = 1 LINE = 1 COLUMN = 1 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 = ITEMID PROMPT_POSITION = ABOVE PROMPT_REPEAT = OFF ENDDEFINE FIELD DEFINE FIELD NAME = PRODID DATATYPE = NUMBER LENGTH = 8 DISPLAY_LENGTH = 8 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 = PRODID PROMPT_POSITION = ABOVE PROMPT_REPEAT = OFF ENDDEFINE FIELD DEFINE FIELD NAME = ACTUALPRICE DATATYPE = NUMBER LENGTH = 10 DISPLAY_LENGTH = 10 QUERY_LENGTH = 10 BASE_TABLE = ON PRIMARY_KEY = OFF MANDATORY = OFF DISPLAYED = ON PAGE = 1 LINE = 1 COLUMN = 21 HELP = Enter value for : ACTUALPRICE 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 = ACTUALPRIC PROMPT_POSITION = ABOVE PROMPT_REPEAT = OFF ENDDEFINE FIELD DEFINE FIELD NAME = QTY DATATYPE = NUMBER LENGTH = 10 DISPLAY_LENGTH = 10 QUERY_LENGTH = 10 BASE_TABLE = ON PRIMARY_KEY = OFF MANDATORY = OFF DISPLAYED = ON PAGE = 1 LINE = 1 COLUMN = 34 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 = QTY PROMPT_POSITION = ABOVE PROMPT_REPEAT = OFF ENDDEFINE FIELD DEFINE FIELD NAME = ITEMTOT DATATYPE = NUMBER LENGTH = 10 DISPLAY_LENGTH = 10 QUERY_LENGTH = 10 BASE_TABLE = ON PRIMARY_KEY = OFF MANDATORY = OFF DISPLAYED = ON PAGE = 1 LINE = 1 COLUMN = 47 HELP = Enter value for : ITEMTOT 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 = ITEMTOT PROMPT_POSITION = ABOVE PROMPT_REPEAT = OFF ENDDEFINE FIELD DEFINE FIELD NAME = ORDID DATATYPE = NUMBER LENGTH = 6 DISPLAY_LENGTH = 6 QUERY_LENGTH = 6 BASE_TABLE = ON PRIMARY_KEY = OFF MANDATORY = ON DISPLAYED = OFF PAGE = 1 LINE = 1 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 = 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 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 = Enter value for : STATE 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 = 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 = 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 = 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 LINE = 2 BOILER = <<< ======== ORDERS ======== >>> LINE = 10 BOILER = <<< ======== ITEMS ======== >>> ENDDEFINE PAGE DEFINE PAGE PAGE = 2 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 LINE = 2 BOILER = <<< ======== CUSTOMERS ======== >>> ENDDEFINE PAGE ENDDEFINE SCREEN ENDDEFINE FORM