jBase Query Language LIST-LABEL

Outputs data in a format suitable for producing labels.

Command Syantax

LIST-LABEL file-specifier {record-list} {selection-criteria} {sort-criteria} {USING file-specifier}{output-specification} {format-specification} {(options}

Prompt

At the prompt, supply formatting criteria as follows:

COL, ROW, SKIP, INDENT, SIZE, SPACE{C}:

COL	The number of columns required to list the data across the page.
ROW	Number of lines for each record; Each element of the output specification appears on a separate line, if more elements exist in the output specification than rows specified it ignores the extra elements. If you specify more rows than elements, the output specification for these rows will be blank.
SKIP	Number of blank lines between each record.
INDENT	Number of spaces for left margin.
SIZE	Number of spaces required for the data under each column.
SPACE	Number of horizontal spaces to skip between columns
C	Optional: Suppresses null or missing data; If absent, outputs null or missing values as blanks. If present, the C must be upper case and not in quotes

Comments: The total number of columns specified must not exceed the page width, based on the calculation:
COLs * (SIZE + SPACE) + INDENT <= page width ROW must be a minimum of one for each field, plus one for the record key (if not suppressed). If the record keys are not suppressed, the first row of each label will contain the record key. If INDENT is not zero, at the prompt supply a series of HEADERs that will appear in the left margin for each field. If a heading is not required for a particular line, press .
Multivalued fields appear as separate labels.
If specified, COL-HDR-SUPP or HDR-SUPP, or the C or H options, the page number, date, and time will not be output and generates the report without page breaks. You must specify a sort criteria clause to sort the records.

See also the SORT-LABEL Command.

Example

LIST-LABEL ORDER ORD.ID ORD.CUS.REF ID-SUPP (C COL,ROW,SKIP,INDENT,SIZE,SPACE(,C):
2,5,2,0,25,4,C 
PAGE 1 13:06:26 15 NOV 2004
Order 30058475 30058488
Orderid 404343 235
Customer Ref
Order 30058501 30058476
Orderid PO 30232 0500444
Customer Ref
Order 30058489 30058502
Orderid 658 2202FR
Customer Ref
Order 30058490 30058477
Orderid 1254 PO 76876

Output of above cannot be shown here correctly