Kbase P146534: Query with break option returns the same record twice
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
29/10/2009 |
|
Status: Unverified
SYMPTOM(s):
Query with break option returns the same record twice
Problem occurs when using dynamic and static queries
FACT(s) (Environment):
Using get-first method and break by option
All Supported Operating Systems
OpenEdge 10.x
CAUSE:
The reason for this behavior is due to the get-first. The break by option can only be used with get-next. Therefore, any get-first, get-last or get-prev is forbidden.
FIX:
To be able to retrieve the correct records, change the get-first to get-next, as indicated in the example below.