LIST-TABLE

Generates a formatted listing of the contents of a file based on the selection criteria entered in the same way as LIST, but tabulated in a similar way to an SQL SELECT statement, and without pagination.

Syntax

LIST-TABLE file-specifier {item-list} {selection-criteria} {USING file-specifier} {sort-criteria} {output-specification} {format-specification} {macro-call} {(options}

Refer to Sentence Structure for descriptions of these parameters and the standard options.

Special options

S Displays a summary at the end of the listing.

Comments

As the width of the columns cannot be determined until all the data has been processed, large data sets will take longer to display.

Example

:LIST-TABLE ROOMS WITH ROOM-CODE "ST" BED-TYPE RATE GUEST-NAME LEAVE-DATE (S
:LIST-TABLE ROOMS WITH ROOM-CODE "ST" BED-TYPE RATE GUEST-NAME LEAVE-DATE (S
┌────────────────────────────────────────────────────────────────┐
│ ROOMS  │ Bed Type      │ Rate    │ Current Guest  │ Leave Date │
├────────────────────────────────────────────────────────────────┤
│ 365    │ WaterBed      │ 104.00  │ Ferguson       │ 29/07/91   │
│ 444    │ King          │ 82.00   │ Curtis         │ 26/07/91   │
│ 222    │ WaterBed      │ 104.00  │ O'Brien        │ 23/07/91   │
│ 478    │ King          │ 82.00   │ Kolman         │ 29/07/91   │
│ 354    │ King          │ 82.00   │ Taylor         │ 27/07/91   │
│ 355    │ King          │ 82.00   │ Taylor         │ 22/07/91   │
│ 318    │ WaterBed      │ 104.00  │ Petrillo       │ 22/07/91   │
│ 600    │ WaterBed      │ 104.00  │ Kerry          │            │
│ 234    │ King          │ 82.00   │ McSweeney      │ 26/07/91   │
└────────────────────────────────────────────────────────────────┘

9 rows in set (0.003 sec)