ALL RECORDS

4D - Documentation   Français   English   German   Spanish   4D v11 SQL, Command Theme List   4D v11 SQL, Command Alphabetical List   4D v11 SQL, Constant Theme List   Back   Previous   Next

version 3


ALL RECORDS {(aTable)}

ParameterTypeDescription
aTableTableTable for which to select all records, or
Default table, if omitted

Description

ALL RECORDS selects all the records of aTable for the current process. ALL RECORDS makes the first record the current record and loads the record from disk. ALL RECORDS returns the records to the default record order, which is the order in which the records are stored on disk.

Example

The following example displays all the records from the [People] table:

   ALL RECORDS ([People])  ` Select all the records in the table 
   DISPLAY SELECTION ([People])  ` Display records in output form

See Also

DISPLAY SELECTION, MODIFY SELECTION, ORDER BY, QUERY, Records in selection, Records in table.


4D - Documentation   Français   English   German   Spanish   4D v11 SQL, Command Theme List   4D v11 SQL, Command Alphabetical List   4D v11 SQL, Constant Theme List   Back   Previous   Next