FIRST RECORD

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


FIRST RECORD {(aTable)}

ParameterTypeDescription
aTableTableTable for which to move to the first selected record,
or Default table, if omitted

Description

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])

See Also

Before selection, End selection, LAST RECORD, NEXT RECORD, PREVIOUS RECORD.


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