Table of Contents

Only

Description

The Only keyword may be used with the List or Sort command to cause the report to list only the keys of the rows being displayed.

Syntax

List Only TABLENAME

Sort Only TABLENAME

Remarks

Use Only when you want to guarantee that the report will list only keys. Only suppresses the default column headings specified in @CRT and @LPTR. Even if display columns are listed in the command, Only will suppress the output of all columns except the key.

Only is useful when listing the contents of tables that contain data that will not display normally, such as BASIC+ object code rows.

To change the width and column heading of the Only column output, edit the @ID row in the dictionary of TABLENAME.

Note:Only can either precede or follow TABLENAME.

Use the command LO for the fastest listing of keys to the screen. LO takes no sort or selection criteria.

Examples

Displays only the keys of rows in the MYTABLE table.

List Only MYTABLE

Displays only the keys of rows in the CUSTOMERS table after sorting the table by key.

Sort Only CUSTOMERS

Displays only the column names of rows in the dictionary of the CUSTOMERS table, and prints the report to the printer

List DICT CUSTOMERS Only (P)