home *** CD-ROM | disk | FTP | other *** search
- ^COMMENT EX_M_13
- ^COMMENT
- ^COMMENT This data file contains the record descriptors that define to Merge
- ^COMMENT the structure of different incoming flat ASCII file records.
- ^COMMENT This example uses 'keyed' record structures which means when
- ^COMMENT Merge is in RECORD MODE it will analyze the record just read
- ^COMMENT and will determine which descriptor applies based on the data
- ^COMMENT value of the key in the incoming record.
- ^COMMENT
- ^COMMENT Once Merge determines which descriptor applies - Merge parses
- ^COMMENT each field value out of the record buffer and Merge internally
- ^COMMENT issues "Field" statements. It is essential that the field names
- ^COMMENT used in the descriptor match the field names designed into the form
- ^COMMENT at form design time. Field names found in the record descriptor
- ^COMMENT that do not appear on the currently active page/subform will be
- ^COMMENT ignored (data will not print) - as is the case with fields called -
- ^COMMENT A_EMP , B_EMP , C_EMP , D_EMP in this example.
- ^COMMENT
- ^COMMENT Note -> field names in the descriptor records that are prefixed
- ^COMMENT with an "*" will be treated as GLOBAL fields by Merge. In this
- ^COMMENT example - global fields include name, address, reference number,
- ^COMMENT reference date, start date, stop date. The field values are supplied
- ^COMMENT once but the fields are populated in both locations on the form
- ^COMMENT where they appear and on subsequent pages as this example
- ^COMMENT spills over to a second page (as described in the text
- ^COMMENT portion below - type C records).
- ^COMMENT
- ^COMMENT FlatFile schema definition for JfMerge for file 'EX_M_1.MDF'.
- ^RECORD EX_M_1_A
- ^CONTINUE A_REC 1
- ^CONTINUE A_EMP 8
- ^CONTINUE *B2_NAME 30
- ^CONTINUE *ADDRESS1 30
- ^CONTINUE *ADDRESS2 30
- ^CONTINUE *ADDRESS3 30
- ^CONTINUE *ADDRESS4 30
- ^CONTINUE *ADDRESS5 30
- ^CONTINUE *REFERENCE 30
- ^KEY A_REC A
- ^RECORD EX_M_1_B
- ^CONTINUE B_REC 1
- ^CONTINUE B_EMP 8
- ^CONTINUE START 8
- ^CONTINUE STOP 8
- ^CONTINUE B3_C1_R1 8
- ^CONTINUE B3_C2_R1 8
- ^CONTINUE B3_C3_R1 8
- ^CONTINUE B3_C1_R2 8
- ^CONTINUE B3_C2_R2 8
- ^CONTINUE B3_C3_R2 8
- ^CONTINUE B3_C1_R3 8
- ^CONTINUE B3_C2_R3 8
- ^CONTINUE B3_C3_R3 8
- ^CONTINUE B3_C1_R4 8
- ^CONTINUE B3_C2_R4 8
- ^CONTINUE B3_C3_R4 8
- ^CONTINUE B3_C1_R5 8
- ^CONTINUE B3_C2_R5 8
- ^CONTINUE B3_C3_R5 8
- ^CONTINUE B3_C1_R6 8
- ^CONTINUE B3_C2_R6 8
- ^CONTINUE B3_C3_R6 8
- ^CONTINUE B3_C1_R7 8
- ^CONTINUE B3_C2_R7 8
- ^CONTINUE B3_C3_R7 8
- ^CONTINUE B3_C1_R8 8
- ^CONTINUE B3_C2_R8 8
- ^CONTINUE B3_C3_R8 8
- ^CONTINUE B3_C1_R9 8
- ^CONTINUE B3_C2_R9 8
- ^CONTINUE B3_C3_R9 8
- ^KEY B_REC B
- ^RECORD EX_M_1_C
- ^CONTINUE C_REC 1
- ^CONTINUE C_EMP 8
- ^CONTINUE B4_TEXT_1 66
- ^KEY C_REC C
- ^RECORD EX_M_1_D
- ^CONTINUE D_REC 1
- ^CONTINUE D_EMP 8
- ^CONTINUE *B4_DATE 8
- ^CONTINUE *B4_NEXT 8
- ^CONTINUE *B4_VALUE 11
- ^CONTINUE B4_PREV 30
- ^KEY D_REC D
- AEMP-1234Tom Hicks 560 Rochester St. Suite 400 Ottawa, Ontario Canada K1S 5K2 EX_M_13.DAT
- BEMP-123401/11/9230/11/92 1.00 2.00 3.00 4.00 5.00 6.00 7.00 8.00 9.00 10.00 11.00 12.00 13.00 14.00 15.00 16.00 17.00 18.00 19.00 20.00 21.00 22.00 23.00 24.00 25.00 26.00 27.00
- DEMP-123401/11/9201/12/92 12,340.00Prev Ref EMP-0012
- CEMP-1234This is a long text field that is presented to Merge 1 line at a
- CEMP-1234time. The area in the form has 1 field of 10 line by 66 characters
- CEMP-1234overlaid by 10 fields of 1 line by 66 characters. The multi line
- CEMP-1234field is used by FillerG for online data capture. The many single
- CEMP-1234line fields are used by Merge for record mode data since record
- CEMP-1234mode cannot support multi line fields.
- CEMP-1234
- CEMP-1234Merge in record mode also counts the number of occurances of a
- CEMP-1234particular record name and compares that number to the number of
- CEMP-1234times the FIRST field named in the structure appears on the
- CEMP-1234page. This comparison will enable Merge to determine if the page
- CEMP-1234is full.
-