LABEL

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