PBDR.COM

About   -   Contact   -   Purchase   -   Search   -   What's New

 
 
ReRetrieve Updated Columns
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.

 

Top of Page

Legal Notice

Ken Howe 2011