Share via

FINDFIRST Function (Record)

  • Article

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

[Ok :=] Record.FINDFIRST

Parameters

  • Record
    Type: Record If the record is found, then it is returned in this parameter and any FlowFields in the record are set to zero. You must update the FlowFields by using the CALCFIELDS Function (Record). If the record is not found and if you omit the return value, then a run-time error occurs.

Property Value/Return Value

Type: Boolean

true if the record was found; otherwise, false.

If you omit this optional return value and the record is not found, then a run-time error occurs. If you include a return value, then you must handle any errors.

Remarks

This function should be used instead of FIND('-') when you only need the first record.

You should only use this function when you explicitly want to find the first record in a table or set. Do not use this function in combination with REPEAT.. UNTIL.

Example

This example requires that you create the following variable.

Variable name Datatype Subtype

SalesSetupRec

Record

Sales & Receivables Setup

This example also assumes that you have a ConfigurePost function.

// Read the first record only. 
IF SalesSetupRec.FINDFIRST THEN BEGIN
  ConfigurePost(SalesSetupRec);
END;

See Also

Reference

FIND Function (Record)
FINDLAST Function (Record)
FINDSET Function (Record)
Record Data Type