Kbase 33867: A FIND, FOR EACH or OPEN QUERY statement generates error 7254
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/05/1998 |
|
Solution ID: P3867
FACT(s) (Environment):
Progress 9.x
SYMPTOM(s):
FIND statement fails with a function that also has a FIND
Illegal FIND, FOR EACH or OPEN QUERY in User-defined function <function name>. (7254)
CAUSE:
A FIND, FOR EACH or OPEN QUERY statement contained a WHERE clause which invoked a user-defined function and that function contained a FIND, FOR EACH or OPEN QUERY statement.
FIX:
Modify the source code so that the user-defined function is called prior to the FIND, FOR EACH or OPEN QUERY statement and its return value is stored in a variable. That variable should then be used in the FIND, FOR EACH or OPEN QUERY statement instead of the reference to the user-defined function.