This browser is no longer supported.

Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.

Version : Available or changed with runtime version 1.0.

Finds the first record in a table based on the current key and filter.

Syntax

[Ok := ]  RecordRef.FindFirst()
Parameters
RecordRef

 Type: RecordRef

An instance of the RecordRef data type.
Return Value
[Optional] Ok

 Type: Boolean

true if the operation was successful; otherwise false.   If you omit this optional return value and the operation does not execute successfully, a runtime error will occur.
Remarks
You should use this method instead of Find('-') when you need only the first record.
You should use this method only when you explicitly want to find the first record in a table or set. Do not use this method in combination with repeat..until.
Example
The following example opens the Item table (27) as a RecordRef variable that is named ItemRecref. The FindFirst method searches for the first record in the table. If the record is found, the description and unit price of the item in the record are displayed in a message box. Otherwise, a message that indicates that the first item was not found is displayed.
    ItemRecref: RecordRef;
    Text000: Label 'The first item is %1 and the unit price is %2.';
    Text001: Label 'The first item was not found.';
begin 
    ItemRecref.Open(27);  
    if ItemRecref.FindFirst then  
      Message(Text000, ItemRecref.Field(3),  ItemRecref.Field(18))  
      Message(Text001);  
See Also
RecordRef Data Type

Get Started with AL

Developing Extensions