recordref-findlast-method.md

title	description	ms.author	ms.date	ms.tgt_pltfrm	ms.topic	author
RecordRef.FindLast() Method	Finds the last record in a table based on the current key and filter.	solsen	02/26/2024	na	reference	SusanneWindfeldPedersen

RecordRef.FindLast() Method

Version: Available or changed with runtime version 1.0.

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

Syntax

[Ok := ]  RecordRef.FindLast()

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 last record.

You should use this method only when you explicitly want to find the last 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 FindLast method searches for the last 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 last item was not found is displayed.

var
    ItemRecref: RecordRef;
    Text000: Label 'The last item is %1 and the unit price is %2.';
    Text001: Label 'The last item was not found.';
begin    
    ItemRecref.Open(27);  
    if ItemRecref.FindLast then  
      Message(Text000, ItemRecref.Field(3),  ItemRecref.Field(18))  
    else  
      Message(Text001);  
end;
  

See Also

RecordRef Data Type
Get Started with AL
Developing Extensions