Kbase P149498: Browse and Query can get out of sync if other session deletes record when scrolling browse with keyb
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
7/31/2009 |
|
Status: Unverified
SYMPTOM(s):
Browse and Query can get out of sync if other session deletes record when scrolling browse with keyboard
Record is visible in browse widget
Record is deleted outside of browse (in another procedure or another session)
Deleted record is selected in browse widget
Query buffer contains first record in query
FACT(s) (Environment):
No record is expected to be available as the record the browse points to no longer exists
OpenEdge 10.x
All Supported Operating Systems
CAUSE:
Bug# OE00188619
FIX:
Workaround:
Add the following code to the browse's VALUE-CHANGED trigger:
<browse-handle>:FETCH-SELECTED-ROW(1) NO-ERROR.
IF ERROR-STATUS:NUM-MESSAGES > 0 AND ERROR-STATUS:GET-number(1) = 385
THEN RELEASE <buffer name>.
This will force an attempt to fetch the deleted record, which will fail.
When this fails, the buffer is then emptied.