| After performing an update to is normal to reretrieve all the rows so
that the timestamps are refreshed. This is a big overhead but Sybase have come to the
rescue with a function reselectrow(). This function is useful for reselected rows when a
update failed due to a timestamp or for reselecting all rows that have been updated.
You will need to loop around all rows finding out which ones were updated. And
performing a reselectrow on each in turn. You can achieve this by asking PB not to reset
the flags on an update dw_1.Update( TRUE, FALSE ) then when you have
reselected the rows you perform the reset of the flags using ResetUpdate().
I would only recommend this method for situations where the user is updating < 10%
of the data, any more and a complete reretrieve would probably be quicker. |