Kbase P16298: No error using CAN-FIND in WHERE clause
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
27/04/2009 |
|
Status: Unverified
SYMPTOM(s):
No error using CAN-FIND in WHERE clause
Progress does not find a record when placing a call to a function into a criteria of the FIND's WHERE clause and the called function contains another (CAN-)FIND statement in its code.
Expected error 7254.
Illegal FIND, FOR EACH or OPEN QUERY in User-defined function <function name>. (7254)
FACT(s) (Environment):
All Supported Operating Systems
Progress 9.x
OpenEdge 10.x
CAUSE:
This is a known issue.
FIX:
Define a variable to store the value that the function returns and then, use that defined variable on the WHERE criteria.