Kbase P71803: In specific situations, result list becomes invalid
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.x
SYMPTOM(s):
In specific situations, result list becomes invalid
GET-LAST() method yields true even when there is no entry in the results list
CAUSE:
When possible, Progress performs optimizations for GET LAST and REPOSITION statements. These optimizations make the results list invalid. At that point, CURRENT-RESULT-ROW returns the unknown value (?). These optimizations do not occur if the query is opened with the PRESELECT option or has an associated browse widget
FIX:
Add a BY clause or PRESELECT option to your query, for example:
hQuery:QUERY-PREPARE("PRESELECT EACH order WHERE " + cClausula + " NO-LOCK").