DISPLAY
Purpose
Display the contents of the active table and any related tables
Syntax
DISPLAY [<scope>]
[FIELDS <field list>|<exp list>]
[FOR <condition>]
[HEADING]
[OFF]
[TO FILE <.txt filename> | (<expC>)] | [TO PRINT]
[WHILE <condition>]
See Also
DB_PRINT, DIR, DISPLAY MEMORY, DISPLAY STATUS, DISPLAY STRUCTURE, Function Keys, LIST, SET FILTER, SET HEADING, SET PAGELENGTH, SET PAGEWIDTH, SET PRINTER, SET RELATION, USE
Description
The DISPLAY command is a general purpose Recital/4GL query command that retrieves and displays the contents of table files on the screen. The DISPLAY command pauses every 17 lines until a key is pressed to continue displaying, or the [ABANDON] key to cancel. When displaying a record that is longer than the screen width, the contents to the right of the display normally will not be displayed unless you have set your terminal to wrap. Consult the relevant manual for your terminal regarding this feature. Where the output is sent to a file or printer, the pause is disabled.
DISPLAY is more powerful than it looks initially. The expressions that you specify can be any valid Recital/4GL expression, including the use of alias pointers into other workareas. If you have SET RELATION TO another table, for each record that is read from the active table, the related table will have its record pointer positioned, and the appropriate record read into its workarea.
If SET FILTER TO <condition> is in effect, only those records that satisfy the filter <condition> will be displayed. If SET DESCRIPTIONS and SET HEADING are ON and the FIELDS clause is specified, the table field descriptions will be used as the headings to each of the display columns, rather than the field names. The command SET HEADING TO SINGLE | DOUBLE | NONE controls the underlining of the column headings.
| Keyword | Description |
|---|---|
| <scope> | If the <scope> is not specified, only the current record will be displayed, unless the WHILE clause is used, in which case the <scope> will default to REST.. |
| FOR <condition> | Only those records that satisfy the <condition> are displayed. |
| OFF | Disables the display of the record number in the first column of the results. |
| FIELDS <exp list> | Restricts the fields displayed to those specified. |
| HEADING | A heading corresponding to either the field names or the expression will be displayed above each column even if SET HEADING is OFF. |
| 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. |
| WHILE <condition> | The <scope> defaults to REST and records are displayed until the <condition> becomes false. |
Example
use patrons index events, names display all fields name, event for event = "BALLET" seek "OPERA" display rest name, event, seats, price, seats * price while event = "OPERA"
Products
Recital Server, Recital
