4D v14.3

FIRST RECORD

Home

 
4D v14.3
FIRST RECORD

FIRST RECORD 


 

FIRST RECORD {( aTable )} 
Parameter Type   Description
aTable  Table in Table for which to move to the first selected record, or Default table, if omitted

FIRST RECORD makes the first record of the current selection of aTable the current record, and loads the record from disk. All query, selection, and sorting commands also set the current record to the first record. If the current selection is empty or if the current record is already the first record of the selection, FIRST RECORD has no effect.

This command is most often used after the USE SET command to begin looping through a selection of records from the first record. However, you can also call it from a subroutine if you are not sure whether or not the current record is actually the first.

Example  

The following example makes the first record of the [Customers] table the first record:

 FIRST RECORD([Customers])

 
PROPERTIES 

Product: 4D
Theme: Selection
Number: 50

This command changes the currrent record

 
HISTORY 

Created: < 4D v6

 
SEE ALSO 

Before selection
End selection
LAST RECORD
NEXT RECORD
PREVIOUS RECORD

 
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)