Kbase P49350: Is there any equivalent for field list option from FOR EACH statement but using FIND statement?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
7/26/2006 |
|
Status: Verified
GOAL:
Is there any equivalent for field list option from FOR EACH statement but using FIND statement?
GOAL:
Can the FIND statement use a field list?
FIX:
The FIND statement is designed to bring an entire single record back to the client. As such, it does not support the use of a field list.
If you simply need to determine if a record exists but do not actually need to retrieve it from the database consider using CAN-FIND instead.
If you do need to rerieve the record and do need to use a field list then use code similar to the following:
FOR FIRST SomeTable FIELDS(.....) WHERE SomeField = SomeValue NO-LOCK:
... processing for record goes here ...
END.