Difference between revisions of "LABEL"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) |
Helengeorge (Talk | contribs) (→Class) |
||
| Line 1: | Line 1: | ||
| − | |||
| − | |||
Revision as of 13:42, 26 October 2009
Purpose
Generate mailing labels from a specified label format definition
Syntax
LABEL FORM <.lbl filename> | (<expC>)
[<scope>]
[FOR <condition>]
[FRAME]
[SAMPLE]
[SEPARATE]
[TO FILE <.txt filename> | (<expC>)]
[TO PRINT]
[TO TERMINAL]
[WHILE <condition>]
[WIDTH <expN>]
See Also
CREATE LABEL, DB_PRINT, MODIFY LABEL, SET PRINTER, TREPORT
Description
The LABEL command is used to generate and print mailing and other labels. It operates by reading the format/layout of the labels from the <.lbl filename>. If no file extension is specified in the form file name, ".lbl" is assumed. The filename can be substituted with a <expC>, enclosed in round brackets, which returns a valid filename.
| Keyword | Description |
|---|---|
| <scope> | If no <scope> is specified, the default is ALL, unless the WHILE clause is used, in which case the <scope> will default to REST. |
| FOR <condition> | If the FOR clause is specified, only those records which satisfy the <condition> are selected. |
| FRAME | The FRAME keyword puts a box around each label. |
| SAMPLE | The SAMPLE option may be used to print sample labels, allowing you to line up the labels in the printer. |
| SEPARATE | The SEPARATE keyword causes each row of labels to be separated by a line. |
| TO <file> | The display output will be sent to the specified file. The filename can be substituted with a <expC>, enclosed in round brackets, which returns a valid filename. If no file extension is specified, then ".txt" will be used. The command SET PAGELENGTH governs the output file pagination and SET PAGEWIDTH defines the width of each page. Page numbers are centered on the bottom of the page according to width. |
| TO PRINT | The display output will be sent to a printer. The TO PRINT option will default to a local printer unless the command SET PRINTER TO \\SPOOLER is issued. The print request will then be spooled to the system printer, which is defined by the environment variable DB_PRINT. |
| TO TERMINAL | The TO TERMINAL keyword outputs labels in pages to the issuing terminal. The user will be prompted to press a key between pages. |
| WHILE <condition> | The WHILE <condition> can be used to restrict the range of records which are scanned in a table, and should be used to optimize the execution of the command. If the WHILE <condition> is used, then the <scope> will default to REST. |
| WIDTH <expN> | The WIDTH clause specifies the number of labels to print across the page. The numeric expression <expN> denotes the number of labels. |
Example
use patrons index events, names label form mail to print for event = "DANCE" set printer to \\spooler seek "BALLET" label form mail to print while event = "BALLET" set printer to
Products
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
