Kbase P120196: Syntax error when using query expression as the value of a function.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/8/2006 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1D
Progress 9.1E
OpenEdge 10.x
SYMPTOM(s):
Syntax error when using query expression as the value of a function.
The following error message is displayed:
Syntax error at or about (statement excerpt). (10713)
CAUSE:
OpenEdge SQL currently does not support using a query expression as the value of a function. All values in a function must be value expressions and not sub-queries.
FIX:
Avoid the use of sub-queries within a function. If that is necessary try assigning the sub-query result to a field within a table and then use that field as a value for the function.