home *** CD-ROM | disk | FTP | other *** search
- FORM ORDERS
-
- COLOR 7
- EXECUTE_MODE CONCURRENT
- DDE_SERVER
- AUTO_COMMMIT USE_DEFAULT
-
- QUERY REFERENCE JNKMAIN SELECT DUMMYCOL
- FROM DEMO.DUMMY
-
-
-
-
- END_QUERY
-
- QUERY INPUT ORDERS SELECT *
- FROM DEMO.TRANSACT
- WHERE CNO = :CNO AND TRANSTYPE='ORDER'
-
-
-
-
- END_QUERY
-
- QUERY INPUT LINE SELECT *
- FROM DEMO.LINE
- WHERE ONO=:ONO
-
-
-
-
- END_QUERY
-
- BITMAP 98 3 608 413
- FILE C:\WINBASE\DEMO\LOGO.PCX
-
- BOX 20 332 1544 637
- TITLE CUSTOMER INFORMATION
-
- BOX 1576 332 2051 637
- TITLE Form Control
-
- BOX 16 683 1963 1398
- TITLE ORDERS
-
- LINE 117 965 1836 965
-
- LINE 1466 1300 1827 1300
-
- REPEATED 117 965 1833 1300
- QUERY_NAME LINE
-
- ENTRY 380 26 2054 159
- DATA_TYPE CHARACTER
- QUERY_NAME JNKMAIN
- TYPE EXPRESSION
- EXPRESSION 'CUSTOMER ORDER FORM'
- JUSTIFICATION CENTER
- COLOR 1
- STYLE 7
- FONT 32 Tms Rmn
-
- ENTRY 436 192 1216 270
- DATA_TYPE CHARACTER
- QUERY_NAME JNKMAIN
- TYPE EXPRESSION
- EXPRESSION 'Enter Customer Number:'
- JUSTIFICATION RIGHT
- COLOR 4
- STYLE 1
- FONT 17 Helv
-
- ENTRY 1245 202 1456 270
- DATA_TYPE SMALL_INTEGER
- QUERY_NAME JNKMAIN
- TYPE INPUT
- EXPRESSION 10
- CELL_NAME CNO
- ENTRY_NUM 1
- ENTERABLE TRUE
- SEARCHABLE DEMO.CUST CUSTNO
- ZOOM_FORM CUST
- VALIDATION MUST_MATCH DEMO.CUST CUSTNO
- INVALID Customer does not exist
- JUSTIFICATION LEFT
- GROUPING
- EXPO_START 13
-
- ENTRY 120 361 1459 445
- DATA_TYPE CHARACTER
- QUERY_NAME JNKMAIN
- TYPE EXPRESSION
- EXPRESSION MATCHROW(':CNO','NAME','')
- JUSTIFICATION LEFT
- COLOR 1
- STYLE 1
- FONT 17 Tms Rmn
-
- ENTRY 120 445 1459 533
- DATA_TYPE CHARACTER
- QUERY_NAME JNKMAIN
- TYPE EXPRESSION
- EXPRESSION MATCHROW(':CNO','ADDRESS','')
- JUSTIFICATION LEFT
- COLOR 1
- STYLE 1
- FONT 17 Tms Rmn
-
- ENTRY 120 533 1459 618
- DATA_TYPE CHARACTER
- QUERY_NAME JNKMAIN
- TYPE EXPRESSION
- EXPRESSION CONCAT(MATCHROW(':CNO','CITY',''),', ',MATCHROW(':CNO','STATE',''),'. ',MATCHROW(':CNO','ZIP',''))
- JUSTIFICATION LEFT
- COLOR 1
- STYLE 1
- FONT 17 Tms Rmn
-
- ENTRY 663 722 1060 787
- DATA_TYPE CHARACTER
- QUERY_NAME ORDERS
- TYPE EXPRESSION
- EXPRESSION 'ORDER NO'
- JUSTIFICATION CENTER
- STYLE 4
-
- ENTRY 1092 722 1489 787
- DATA_TYPE CHARACTER
- QUERY_NAME ORDERS
- TYPE EXPRESSION
- EXPRESSION 'ORDER DATE'
- JUSTIFICATION CENTER
- STYLE 4
-
- ENTRY 1511 722 1908 787
- DATA_TYPE CHARACTER
- QUERY_NAME ORDERS
- TYPE EXPRESSION
- EXPRESSION 'SHIP DATE'
- JUSTIFICATION CENTER
- STYLE 4
-
- ENTRY 29 796 618 868
- DATA_TYPE CHARACTER
- QUERY_NAME ORDERS
- TYPE EXPRESSION
- EXPRESSION CONCAT('#',CHAR(RECORDNUM,0),' OF ',CHAR(NUMRECS,0),' ORDER(S)')
- JUSTIFICATION CENTER
- COLOR 1
- STYLE 1
- FONT 14 Helv
-
- ENTRY 637 796 1086 871
- DATA_TYPE CHARACTER
- QUERY_NAME ORDERS
- TYPE EXPRESSION
- EXPRESSION TRANSNO
- CELL_NAME ONO
- JUSTIFICATION LEFT
- COLOR 1
- STYLE 1
- FONT 14 Helv
-
- ENTRY 1121 796 1443 871
- DATA_TYPE CHARACTER
- QUERY_NAME ORDERS
- TYPE EXPRESSION
- EXPRESSION TRANSDATE
- JUSTIFICATION LEFT
- COLOR 1
- STYLE 1
- FONT 14 Helv
-
- ENTRY 1550 796 1872 855
- DATA_TYPE DATE
- QUERY_NAME ORDERS
- DATABASE SHIPDATE
- TYPE INPUT
- EXPRESSION nulld
- ENTRY_NUM 2
- ENTERABLE TRUE
- JUSTIFICATION CENTER
- COLOR 1
- STYLE 1
- FONT 14 Helv
- FORMAT MM/DD/YY
-
- ENTRY 127 887 380 952
- DATA_TYPE CHARACTER
- QUERY_NAME JNKMAIN
- TYPE EXPRESSION
- EXPRESSION 'PROD#'
- JUSTIFICATION RIGHT
-
- ENTRY 403 887 933 952
- DATA_TYPE CHARACTER
- QUERY_NAME JNKMAIN
- TYPE EXPRESSION
- EXPRESSION 'DESCRIPTION'
- JUSTIFICATION CENTER
-
- ENTRY 956 887 1157 952
- DATA_TYPE CHARACTER
- QUERY_NAME JNKMAIN
- TYPE EXPRESSION
- EXPRESSION 'QTY'
- JUSTIFICATION RIGHT
-
- ENTRY 1180 887 1443 952
- DATA_TYPE CHARACTER
- QUERY_NAME JNKMAIN
- TYPE EXPRESSION
- EXPRESSION 'PRICE'
- JUSTIFICATION RIGHT
-
- ENTRY 1456 887 1784 952
- DATA_TYPE CHARACTER
- QUERY_NAME JNKMAIN
- TYPE EXPRESSION
- EXPRESSION 'AMOUNT'
- JUSTIFICATION RIGHT
-
- ENTRY 140 982 358 1047
- DATA_TYPE SMALL_INTEGER
- QUERY_NAME LINE
- DATABASE PNO
- TYPE INPUT
- EXPRESSION PNO
- CELL_NAME PNO
- ENTRY_NUM 3
- ENTERABLE TRUE
- SEARCHABLE DEMO.PROD PRODNO
- ZOOM_FORM PROD
- VALIDATION MUST_MATCH DEMO.PROD PRODNO
- INVALID Product must exist!
- JUSTIFICATION RIGHT
- STYLE 1
- FONT 14 Helv
- GROUPING
- EXPO_START 13
-
- ENTRY 403 982 933 1047
- DATA_TYPE CHARACTER
- QUERY_NAME LINE
- TYPE EXPRESSION
- EXPRESSION MATCHROW(':PNO','DESCRIP','-none-')
- JUSTIFICATION LEFT
- COLOR 1
- STYLE 1
- FONT 14 Helv
-
- ENTRY 956 982 1157 1047
- DATA_TYPE SMALL_INTEGER
- QUERY_NAME LINE
- DATABASE QTY
- TYPE INPUT
- EXPRESSION QTY
- CELL_NAME QTY
- ENTRY_NUM 4
- ENTERABLE TRUE
- JUSTIFICATION RIGHT
- STYLE 1
- FONT 14 Helv
- GROUPING
- EXPO_START 13
-
- ENTRY 1180 982 1443 1047
- DATA_TYPE FLOAT
- QUERY_NAME LINE
- DATABASE PRICE
- TYPE EXPRESSION
- EXPRESSION MATCHROW(':PNO','LISTPRICE',0.0)
- CELL_NAME PRICE
- JUSTIFICATION RIGHT
- COLOR 1
- STYLE 1
- FONT 14 Helv
- SCALE 2
- EXPO_START 13
-
- ENTRY 1466 982 1794 1047
- DATA_TYPE DECIMAL
- QUERY_NAME LINE
- DATABASE AMT
- TYPE EXPRESSION
- EXPRESSION DEC(:PRICE * :QTY)
- CELL_NAME AMT
- JUSTIFICATION RIGHT
- COLOR 1
- STYLE 1
- FONT 14 Helv
- SCALE 2
- GROUPING
- EXPO_START 13
-
- ENTRY 29 1001 94 1076
- DATA_TYPE CHARACTER
- QUERY_NAME LINE
- DATABASE ONO
- TYPE EXPRESSION
- EXPRESSION :ONO
- JUSTIFICATION LEFT
- COLOR 7
- STYLE 1
- FONT 14 Helv
-
- ENTRY 1053 1307 1450 1381
- DATA_TYPE CHARACTER
- QUERY_NAME ORDERS
- TYPE EXPRESSION
- EXPRESSION 'ORDER AMT:'
- JUSTIFICATION RIGHT
-
- ENTRY 1456 1307 1788 1378
- DATA_TYPE DECIMAL
- QUERY_NAME ORDERS
- DATABASE TRANSAMT
- TYPE EXPRESSION
- EXPRESSION SUM(:AMT)
- CELL_NAME SUMORD
- JUSTIFICATION RIGHT
- COLOR 1
- STYLE 1
- FONT 14 Helv
- SCALE 2
- GROUPING
- CURRENCY
- EXPO_START 13
-
- BUTTON 1502 195 1755 280
- TYPE SEARCH
- TITLE &Search
-
- BUTTON 1619 377 1999 471
- TYPE SAVE
- TITLE SAVE CHANGES
-
- BUTTON 1619 501 1999 598
- TYPE UNDO
- TITLE CANCEL CHGS
-
- BUTTON 111 705 536 783
- QUERY_NAME ORDERS
- TYPE DELETE
- TITLE Delete Order
-
- BUTTON 153 1303 553 1378
- QUERY_NAME LINE
- TYPE NEW
- TITLE New Item
-
- BUTTON 579 1303 975 1378
- QUERY_NAME LINE
- TYPE DELETE
- TITLE Delete Item
-
- SCROLL_BAR 1973 683 2048 1401
- QUERY_NAME ORDERS
-
- SCROLL_BAR 1856 965 1937 1264
- QUERY_NAME LINE
-
-