home *** CD-ROM | disk | FTP | other *** search
Text File | 1991-03-04 | 26.1 KB | 1,205 lines |
-
- /* Copyright (c) 1988 by the Oracle Corporation */
-
-
- SQL*FORMS_VERSION = 03.00.14.00.02
-
- DEFINE FORM
-
- NAME = SAMPLE
- TITLE = NEWFORM
- DEFAULT_MENU_APPLICATION =
- ROOT_MENU =
- GROUP_NAME =
- MOUSE_NAVIGATION_LIMIT =
- VALIDATION_UNIT =
-
- DEFINE BLOCK
-
- NAME = orders
- DESCRIPTION = orders
- TABLE = ORD
- UNIQUE_KEY = OFF
- UPDATE_KEY = OFF
- IN_MENU = ON
- ROWS_DISPLAYED = 1
- ROWS_BUFFERED = 1
- BASE_LINE = 1
- LINES_PER_ROW = 0
- ARRAY_SIZE = 0
- COLUMN_SECURITY = OFF
- ORDERING = <<<
- ORDER BY ORDID
- >>>
-
- DEFINE FIELD
-
- NAME = ORDID
- DATATYPE = NUMBER
- LENGTH = 44
- DISPLAY_LENGTH = 4
- QUERY_LENGTH = 44
- BASE_TABLE = ON
- PRIMARY_KEY = OFF
- MANDATORY = OFF
- DISPLAYED = ON
- PAGE = 1
- LINE = 6
- COLUMN = 16
- HELP = Enter value for : ORDERID
- 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 = OFF
- 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 =
- 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 = 6
- COLUMN = 46
- 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 = OFF
- 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 = CUSTID
- DATATYPE = NUMBER
- LENGTH = 44
- DISPLAY_LENGTH = 10
- QUERY_LENGTH = 44
- BASE_TABLE = ON
- PRIMARY_KEY = OFF
- MANDATORY = OFF
- DISPLAYED = ON
- PAGE = 1
- LINE = 8
- COLUMN = 16
- HELP = Enter value for : CLIENTID
- LOW_VALUE =
- HIGH_VALUE =
- LOV_TEXT = <<<
- SELECT NAME,CUSTID INTO :ORDERS.NAME, :ORDERS.CUSTID
- FROM CUSTOMER
- ORDER BY NAME
- >>>
- LOV_TITLE = COMPANY
- LOV_X = 10
- LOV_Y = 10
- INPUT_MASK =
- OUTPUT_MASK =
- EDIT_X = 0
- EDIT_Y = 0
- EDIT_TOP_TITLE =
- EDIT_BOTTOM_TITLE =
- EDIT_WORD_WRAP = OFF
- 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
-
- DEFINE TRIGGER
-
- NAME = POST-CHANGE
- TRIGGER_TYPE = V2
- SHOW_KEY = ON
- DESCRIPTION =
-
- DEFINE STEP
-
- LABEL =
- TEXT = <<<
- SELECT NAME
- INTO ORDERS.NAME
- FROM CUSTOMER
- WHERE :ORDERS.CUSTID = CUSTOMER.CUSTID
- >>>
- SUCCESS_STEP =
- FAILURE_STEP =
- FAIL_MESSAGE =
- ABORT = ON
- REVERSE = OFF
- NEW_CURSOR = OFF
- IGNORE = OFF
-
- ENDDEFINE STEP
-
- ENDDEFINE TRIGGER
-
- ENDDEFINE FIELD
-
- DEFINE FIELD
-
- NAME = NAME
- DATATYPE = CHAR
- LENGTH = 14
- DISPLAY_LENGTH = 14
- QUERY_LENGTH = 14
- BASE_TABLE = OFF
- PRIMARY_KEY = OFF
- MANDATORY = OFF
- DISPLAYED = ON
- PAGE = 1
- LINE = 8
- COLUMN = 46
- HELP =
- LOW_VALUE =
- HIGH_VALUE =
- LOV_TEXT = <<<
- SELECT NAME, CUSTID INTO :ORDERS.NAME,:ORDERS.CUSTID
- FROM CUSTOMER
- ORDER BY NAME
- >>>
- LOV_TITLE = custname
- LOV_X = 10
- LOV_Y = 10
- INPUT_MASK =
- OUTPUT_MASK =
- EDIT_X = 0
- EDIT_Y = 0
- EDIT_TOP_TITLE =
- EDIT_BOTTOM_TITLE =
- EDIT_WORD_WRAP = OFF
- 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
-
- ENDDEFINE BLOCK
-
- DEFINE BLOCK
-
- NAME = lineitems
- DESCRIPTION = lineitems
- TABLE = ITEM
- UNIQUE_KEY = OFF
- UPDATE_KEY = OFF
- IN_MENU = ON
- ROWS_DISPLAYED = 3
- ROWS_BUFFERED = 3
- BASE_LINE = 16
- LINES_PER_ROW = 1
- ARRAY_SIZE = 0
- COLUMN_SECURITY = OFF
- ORDERING =
-
- DEFINE FIELD
-
- NAME = ORDID
- DATATYPE = NUMBER
- LENGTH = 44
- DISPLAY_LENGTH = 8
- QUERY_LENGTH = 44
- BASE_TABLE = ON
- PRIMARY_KEY = OFF
- MANDATORY = ON
- DISPLAYED = ON
- PAGE = 1
- LINE = 1
- COLUMN = 6
- HELP = Enter value for : ORDID
- LOW_VALUE =
- HIGH_VALUE =
- LOV_TEXT = <<<
- ORDERS.ORDID
- >>>
- 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 = OFF
- DEFAULT =
- ENFORCE_KEY_FROM = ORDERS.ORDID
- 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 = ITEMID
- DATATYPE = NUMBER
- LENGTH = 44
- DISPLAY_LENGTH = 8
- QUERY_LENGTH = 44
- BASE_TABLE = ON
- PRIMARY_KEY = OFF
- MANDATORY = ON
- DISPLAYED = ON
- PAGE = 1
- LINE = 1
- COLUMN = 16
- HELP = Enter value for : ITEMNO
- 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 = OFF
- 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 = PRODID
- DATATYPE = CHAR
- LENGTH = 6
- DISPLAY_LENGTH = 6
- QUERY_LENGTH = 6
- BASE_TABLE = ON
- PRIMARY_KEY = OFF
- MANDATORY = OFF
- DISPLAYED = ON
- PAGE = 1
- LINE = 1
- COLUMN = 26
- 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 = OFF
- DEFAULT =
- ENFORCE_KEY_FROM =
- ECHO = ON
- INPUT = ON
- UPDATE = ON
- UPDATE_NULL = OFF
- QUERY = ON
- FIXED_LENGTH = ON
- AUTOSKIP = OFF
- AUTOHELP = OFF
- UPPERCASE = OFF
- PROMPT =
- PROMPT_POSITION = BESIDE
- 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 = 34
- 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 = OFF
- 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 = QTY
- DATATYPE = NUMBER
- LENGTH = 44
- DISPLAY_LENGTH = 10
- QUERY_LENGTH = 44
- BASE_TABLE = ON
- PRIMARY_KEY = OFF
- MANDATORY = OFF
- DISPLAYED = ON
- PAGE = 1
- LINE = 1
- COLUMN = 46
- 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 = OFF
- 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
-
- DEFINE TRIGGER
-
- NAME = POST-CHANGE
- TRIGGER_TYPE = V2
- SHOW_KEY = ON
- DESCRIPTION =
-
- DEFINE STEP
-
- LABEL =
- TEXT = <<<
- SELECT NVL(:lineitems.actualprice, 0) * nvl(:lineitems.qty, 0)
- into lineitems.itemtot
- from dual
- >>>
- SUCCESS_STEP =
- FAILURE_STEP =
- FAIL_MESSAGE = Total does not compute
- ABORT = ON
- REVERSE = OFF
- NEW_CURSOR = OFF
- IGNORE = OFF
-
- ENDDEFINE STEP
-
- ENDDEFINE TRIGGER
-
- 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 = 58
- 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 = OFF
- 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 = client_data
- DESCRIPTION = client_data
- TABLE = CUSTOMER
- UNIQUE_KEY = OFF
- UPDATE_KEY = OFF
- IN_MENU = ON
- ROWS_DISPLAYED = 1
- ROWS_BUFFERED = 1
- BASE_LINE = 1
- LINES_PER_ROW = 0
- ARRAY_SIZE = 0
- COLUMN_SECURITY = OFF
- ORDERING =
-
- DEFINE FIELD
-
- NAME = repid
- DATATYPE = CHAR
- LENGTH = 4
- DISPLAY_LENGTH = 4
- QUERY_LENGTH = 4
- BASE_TABLE = ON
- PRIMARY_KEY = OFF
- MANDATORY = OFF
- DISPLAYED = OFF
- PAGE = 0
- LINE = 0
- COLUMN = 0
- 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 = OFF
- DEFAULT =
- ENFORCE_KEY_FROM =
- ECHO = ON
- INPUT = OFF
- UPDATE = OFF
- UPDATE_NULL = OFF
- QUERY = OFF
- FIXED_LENGTH = OFF
- AUTOSKIP = ON
- AUTOHELP = OFF
- UPPERCASE = OFF
- PROMPT =
- PROMPT_POSITION = BESIDE
- PROMPT_REPEAT = OFF
-
- ENDDEFINE FIELD
-
- DEFINE FIELD
-
- NAME = CUSTID
- DATATYPE = NUMBER
- LENGTH = 44
- DISPLAY_LENGTH = 10
- QUERY_LENGTH = 44
- BASE_TABLE = ON
- PRIMARY_KEY = OFF
- MANDATORY = ON
- DISPLAYED = ON
- PAGE = 2
- LINE = 6
- COLUMN = 20
- HELP = Enter value for : Client ID
- 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 = OFF
- DEFAULT =
- ENFORCE_KEY_FROM = ORDERS.CUSTID
- 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
-
- /* Press [List Field Values] to view client names. */
-
- NAME = NAME
- DATATYPE = CHAR
- LENGTH = 50
- DISPLAY_LENGTH = 40
- QUERY_LENGTH = 50
- BASE_TABLE = ON
- PRIMARY_KEY = OFF
- MANDATORY = OFF
- DISPLAYED = ON
- PAGE = 2
- LINE = 8
- COLUMN = 20
- HELP = Press [List] to view client names.
- LOW_VALUE =
- HIGH_VALUE =
- LOV_TEXT = <<<
- CUSTOMER.NAME
- >>>
- 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 = OFF
- 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 = ADDRESS
- DATATYPE = CHAR
- LENGTH = 40
- DISPLAY_LENGTH = 40
- QUERY_LENGTH = 40
- BASE_TABLE = ON
- PRIMARY_KEY = OFF
- MANDATORY = OFF
- DISPLAYED = ON
- PAGE = 2
- LINE = 10
- 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 = OFF
- 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 = CITY
- DATATYPE = CHAR
- LENGTH = 30
- DISPLAY_LENGTH = 30
- QUERY_LENGTH = 30
- BASE_TABLE = ON
- PRIMARY_KEY = OFF
- MANDATORY = OFF
- DISPLAYED = ON
- PAGE = 2
- LINE = 12
- 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 = OFF
- 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 = STATE
- DATATYPE = CHAR
- LENGTH = 2
- DISPLAY_LENGTH = 2
- QUERY_LENGTH = 2
- BASE_TABLE = ON
- PRIMARY_KEY = OFF
- MANDATORY = OFF
- DISPLAYED = ON
- PAGE = 2
- LINE = 14
- 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 = OFF
- DEFAULT =
- ENFORCE_KEY_FROM =
- ECHO = ON
- INPUT = ON
- UPDATE = ON
- UPDATE_NULL = OFF
- QUERY = ON
- FIXED_LENGTH = OFF
- AUTOSKIP = ON
- AUTOHELP = OFF
- UPPERCASE = ON
- PROMPT =
- 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 = 14
- COLUMN = 30
- HELP = Enter the 9-digit ZIP code, if available.
- 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 = OFF
- 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 = AREA
- DATATYPE = NUMBER
- LENGTH = 3
- DISPLAY_LENGTH = 3
- QUERY_LENGTH = 4
- BASE_TABLE = ON
- PRIMARY_KEY = OFF
- MANDATORY = OFF
- DISPLAYED = ON
- PAGE = 2
- LINE = 16
- COLUMN = 20
- HELP = Enter area code.
- 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 = OFF
- DEFAULT =
- ENFORCE_KEY_FROM =
- ECHO = ON
- INPUT = ON
- UPDATE = ON
- UPDATE_NULL = OFF
- QUERY = ON
- FIXED_LENGTH = ON
- AUTOSKIP = ON
- AUTOHELP = OFF
- UPPERCASE = OFF
- PROMPT =
- 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 = 16
- COLUMN = 27
- 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 = OFF
- 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 = CREDITLIMIT
- DATATYPE = NUMBER
- LENGTH = 11
- DISPLAY_LENGTH = 10
- QUERY_LENGTH = 11
- BASE_TABLE = ON
- PRIMARY_KEY = OFF
- MANDATORY = OFF
- DISPLAYED = ON
- PAGE = 2
- LINE = 19
- COLUMN = 20
- HELP = Enter value for : CREDITLMT
- 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 = OFF
- 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 = Comments
- DATATYPE = LONG
- LENGTH = 255
- DISPLAY_LENGTH = 40
- QUERY_LENGTH = 255
- BASE_TABLE = ON
- PRIMARY_KEY = OFF
- MANDATORY = OFF
- DISPLAYED = ON
- PAGE = 2
- LINE = 21
- COLUMN = 20
- HELP =
- LOW_VALUE =
- HIGH_VALUE =
- LOV_TEXT =
- LOV_TITLE =
- LOV_X = 0
- LOV_Y = 0
- INPUT_MASK =
- OUTPUT_MASK =
- EDIT_X = 10
- EDIT_Y = 30
- EDIT_TOP_TITLE = COMMENTS
- EDIT_BOTTOM_TITLE =
- EDIT_WORD_WRAP = OFF
- 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 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 = 3
- BOILER = <<<
- O R D E R S
- >>>
- LINE = 6
- BOILER = <<<
- Order ID Order Date
- >>>
- LINE = 8
- BOILER = <<<
- Client ID Client Name
- >>>
- LINE = 12
- BOILER = <<<
- I T E M S
- >>>
- LINE = 15
- BOILER = <<<
- Order ID Item No. Code Act. Price Quantity Item Total
- >>>
- MODE = BOX
- LINE = 2
- BOILER = <<<
- <------------------------------------------------------------------------->
- >>>
- LINE = 11
- BOILER = <<<
- <------------------------------------------------------------------------->
- >>>
-
- 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 = 3
- BOILER = <<<
- C L I E N T D A T A
- >>>
- LINE = 6
- BOILER = <<<
- Client ID
- >>>
- LINE = 8
- BOILER = <<<
- Name
- >>>
- LINE = 10
- BOILER = <<<
- Address
- >>>
- LINE = 12
- BOILER = <<<
- City
- >>>
- LINE = 14
- BOILER = <<<
- State Zip
- >>>
- LINE = 16
- BOILER = <<<
- Phone ( )
- >>>
- LINE = 19
- BOILER = <<<
- Credit Limit
- >>>
- LINE = 21
- BOILER = <<<
- Comments
- >>>
- MODE = BOX
- LINE = 2
- BOILER = <<<
- <------------------------------------------------------------------------->
- >>>
-
- ENDDEFINE PAGE
-
- ENDDEFINE SCREEN
-
- ENDDEFINE FORM
-