4D v14.3

ALL RECORDS

Home

 
4D v14.3
ALL RECORDS

ALL RECORDS 


 

ALL RECORDS {( aTable )} 
Parameter Type   Description
aTable  Table in Table for which to select all records, or Default table, if omitted

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

 
PROPERTIES 

Product: 4D
Theme: Selection
Number: 47

This command changes the currrent recordThe command changes the current selection

 
HISTORY 

Created: < 4D v6

 
SEE ALSO 

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

 
ARTICLE USAGE

4D Language Reference ( 4D v12.4)
4D Language Reference ( 4D v11 SQL Release 6)
4D Language Reference ( 4D v14 R2)
4D Language Reference ( 4D v13.5)
4D Language Reference ( 4D v14 R3)
4D Language Reference ( 4D v14.3)
4D Language Reference ( 4D v14 R4)