A character expression that evaluates to the following syntax:
[ WHERE [ logical-expression ]][ USE-INDEX index-name]
Once evaluated, predicate-expression can contain only constants and unabbreviated references to fields from the buffer.
The predicate-expression itself can be built using a concatenation of character expressions.
lockmode
An integer expression evaluating to one of the following constants: SHARE-LOCK, EXCLUSIVE-LOCK, or NO-LOCK. You can assign any of these constants to an integer variable. For example, mylock = NO-LOCK.
The default is SHARE-LOCK.
waitmode
An integer expression evaluating to one of the following: NO-WAIT, 0, or the Unknown value (?). You can assign NO-WAIT to an integer variable. For example, mywait = NO-WAIT. The default is to wait.
The following shows some examples of FIND-FIRST method:
DEFINE VARIABLE bh AS HANDLE NO-UNDO.
DEFINE VARIABLE myname AS CHARACTER NO-UNDO.
If FIND-FIRST succeeds, it returns TRUE, otherwise it returns FALSE.
If FIND-FIRST fails, it does not raise an error but displays a message. You can suppress this message by using NO-ERROR on the statement containing the method.