Progress Quiz 19

[Progress OpenEdge]

Qn 19: Name the main difference between FIND statement and CAN-FIND() function. What CAN-FIND() returns?
Ans: FIND fetches the record from the database and makes it physically available.
CAN-FIND() just returns a logical yes/no to say whether a record is available in the database

 

[TomBascom]

Correct.

In addition, the default lock for CAN-FIND is NO-LOCK. You should always explicitly state your desired locking but forgetting with CAN-FIND() is less of a problem than with FIND.

 

[Stefan]

The default for FIND can also be NO-LOCK - OpenEdge 11.7 Documentation

 

[Progress OpenEdge]

This is very useful to know, thanks!