Kbase P100299: Error: 'Unable to locate record in current query' when fetched record is not in current data batch r
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
29/10/2008 |
|
Status: Verified
SYMPTOM(s):
Unable to locate record in current query
The application has an SDO that joins three tables.
The SDO is linked to a dynamic SmartDataBrowser with a search field.
The "Unable to locate record in current query" error occurs when searching for a record that is not in the current batch of the query result set.
If the SDO's "read data in batches of" property is set to a very large number, the error no longer occurs.
FACT(s) (Environment):
Progress 9.1D06
CAUSE:
Bug# 20020228-003
CAUSE:
The problem was due to the fact that the return value from rowidWhere; which findRowWhere passes as parameter to fetchRowident; used '?' in the entry for non-existing tables.
FIX:
This issue was fixed in 9.1D08. Upgrade to 9.1D08 or higher.