Back-to-Basics: List-Label

MV Solutions: May 1997

Nathan Rector

list-label {filename} {itemlist} {selectlist} {outlist} ({options}

?{column,row,skip,indent,size,space,c}

The people that use their database for large mailings likely already know about LIST-LABEL. This command is used to format an ACCESS statement to print on some type of label.

Although this command is primarily used to create mailing labels, it can be used for anything that requires labels. The LIST-LABEL is not limited to any specific size of label. The only limitation is not being able to use more than one font or pitch size. You are limited to only using the font and pitch size originally set before the labels are printed.

Since only one font is allowed, you are not able to print bar codes or other symbols that may be needed. This limitation extends to printing graphics as well.

LIST-LABEL allows you to add selection criteria to the TCL sentence. The fields listed in the outlist are displayed on the label. If you are creating mailing labels, then you may have NAME, ADDRESS, CITY, ST, and ZIP. If you are doing packing labels, then you might use the fields JOB#, CUST.NAME, MAIL.ADDR, MAIL.CITY, MAIL.ST, and MAIL.ZIP.

To define what the page of label looks like, the following parameters are used:

column = the number of labels across

row = the number of printable rows on the label

skip = the number of non-printable row between each label

indent = the number of spaces to indent the printed information

size = the number of printable characters on the label. If the length of the printed string exceeds this length, then trim the extra characters off the end.

space = the number of non-printable characters between each label

c = the physical character of 'c'. This keeps blank lines from printing on the label. The 'c' can be keyed in upper or lower case.

Mailing label example:

LIST-LABEL CUSTOMER NAME COMPANY ADDRESS CITY.ST.ZP

?4,5,2,0,4,20,c

Shipping label example:

LIST-LABEL JOB.ORDER JOB.NO CUST.NAME MAIL.ADDR MAIL.CITY.ST.ZP DESC

?2,10,2,0,4,40,c