Kbase P133170: Override procedure for updateRecord that repositions SmartDataBrowser causes new data to disappear w
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
7/11/2008 |
|
Status: Unverified
SYMPTOM(s):
Override procedure for updateRecord that repositions SmartDataBrowser causes new data to disappear when add fails
Override procedure for updateRecord in SmartDataBrowser.
After running the updateRecord super procedure, the override procedure reopens the query and repositions it to place the new record in order among the other records in the browse.
If the add operation fails, the new record disappears from the browse.
FACT(s) (Environment):
Windows
Progress 9.x
OpenEdge 10.x
CAUSE:
Reopening the query repopulates the result set with only those records that are in the database; the record that was not added to the database is lost.
FIX:
Run the code to reopen the query only when the super procedure does not return ADM-ERROR. This will leave the new row in the browse when an error does occur, so the user can make corrections and resubmit the add.