FindLast

Purpose

Finds a record in a record set.

This method begins at the last record and moves backward through the record set until Condition evaluates to TRUE or the end of the record set is reached. Each time the record pointer is moved, Condition is re-evaluated.

If the condition does not evaluate to TRUE and the end of the record set is reached, the NoMatch flag is set to TRUE.

Note

In order to prevent deadlock in asynchronous systems, Find requires server re-entrance for each move and evaluation of Condition. Re-entrance has a substantial amount of overhead and it is often faster and more effective to use the Filter method instead of a Find method.

Syntax

DBStatement.FindLast (Condition)

Condition

Any valid conditional expression.

It is best to include comparisons to columns in the cursor or it is not likely that Condition will evaluate to TRUE.

Compliance:

Level 2

Example

See the example for FindFirst.