Kbase P45504: Is it possible to use the BREAK BY option with a dynamic query?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
17/03/2009 |
|
Status: Verified
GOAL:
Is it possible to use the BREAK BY option with a dynamic query?
FACT(s) (Environment):
All Supported Operating Systems
Progress 8.x
Progress 9.x
OpenEdge 10.0x
OpenEdge 10.1A
OpenEdge 10.1B
FIX:
It is not possible to use BREAK BY in a dynamic query as it is used in a FOR EACH statement because BREAK BY cannot be used with DEFINE QUERY or OPEN QUERY.
The only way to do this would be to detect the BREAK manually with variables after using the BY option on OPEN QUERY.
So, save the current value to break on to a variable and then navigate the query using the GET-NEXT and GET-PREV methods. After each navigation compare the current results list value with the value saved to the variable, indicating a change.