Topic group Related topics
Displays records from the current table in the result pane of the Command window.
[FOR <condition 1>]
[WHILE <condition 2>]
[[FIELDS] <exp list>]
[TO FILE <filename>]
FOR <condition 1>
WHILE <condition 2>
The scope of the command. The default scope is NEXT 1, the current record only.
FIELDS <exp list>
Field names or expressions whose contents (values) you want to display; the names of the fields in the list are separated by commas. If you omit <exp list>, dBASE Plus displays all fields in the current table. The FIELDS keyword is included for readability only; it has no affect on the operation of the command.
Suppresses display of the record number when displaying records from a DBF table.
TO FILE <filename>
Directs output to a file, as well as to the results pane of the Command window. By default, dBASE Plus assigns a .TXT extension to <filename>.
Directs output to the default printer, as well as to the results pane of the Command window.
Use DISPLAY to view one or more records of the current table in the results pane of the Command window. If SET HEADINGS is OFF, dBASE Plus doesn't display field names when you issue DISPLAY. DISPLAY pauses when the results pane is full and displays a dialog box prompting you to display another screenful of information.
Use the TO FILE clause to send the information to a file. Use the TO PRINTER clause to send the information to the printer. In either case, you can use SET CONSOLE OFF to suppress the display of the information in the results pane.
The LIST command is almost identical to DISPLAY, except that:
The default scope for LIST is ALL.
LIST doesn't pause for each screenful of information but rather lists the information continuously. This makes LIST more appropriate when directing output to a file or printer.
Memo fields are displayed as "MEMO" if they contain data or "memo" if they are empty; unless the field is listed in <exp list>, in which case the contents of the memo field is displayed.