Kbase P141851: Incorrect result when using BUFFER-VALUE within a WHERE clause
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
2/25/2009 |
|
Status: Unverified
SYMPTOM(s):
Incorrect result when using BUFFER-VALUE within a WHERE clause
FOR EACH query returns incorrect result when using BUFFER-VALUE
FACT(s) (Environment):
If the BUFFER-VALUE is used within an internal IF statement, the result is correct
All Supported Operating Systems
OpenEdge 10.x
CAUSE:
The BUFFER-VALUE is only evaluated once. Since BUFFER-VALUE is dynamic, it is not possible to know its value in advance and it is not supported in a WHERE clause, except with the observed behavior. All things of the form X:Y in a WHERE clause are extracted and evaluated before the FOR EACH starts up.
FIX:
Use an internal IF statement containing the BUFFER-VALUE