Small company logo:
   History
 
Advertising banner:
 
 Statement.FindNext
Home • Help • Customization Tools • FCAS • Language Reference • Statement.FindNext
 
Purpose
Finds a record in a record set.
This method begins at the current record and moves forward 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.
7202010_20004_0.png        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.FindNext (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.