Progress
Version 9
Product Update Bulletin
FIND-UNIQUE Method
Gets a single record. This method lets a user get a unique record that satisfies the predicate expression
Return Type: LOGICALApplies To: Buffer Object handleThe FIND-UNIQUE method has the following syntax:
SYNTAX
predicate-expression
A character expression that evaluates to the following syntax:
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 NO-LOCK 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 default is to wait.
You can assign NO-WAIT to an integer variable. For example, mywait = NO-WAIT.
The following shows some examples of the FIND-UNIQUE method:
NOTES
- If FIND-UNIQUE succeeds, it returns TRUE, otherwise it returns FALSE.
- If FIND-UNIQUE fails, a message displays. You can suppress this message using NO-ERROR on the statement containing the method.
- If more than one record satisfies the predicate expression, then the AMBIGUOUS attribute is set to TRUE.
SEE ALSO
FIND-FIRST Method, FIND-LAST Method, FIND-CURRENT( ) Method in this bulletin, and the FIND Statement in the Progress Language Reference
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |