Hi John,
I *always* use optimistic table buffering. I do this because of the reason David stated, that if the record pointer moves during row buffering an implicit tableupdate() is issued. I then use TABLEUPDATE(0) to update only one record (the current record) and TABLEUPDATE(1) to update all modified records.
>What general rules/situations does one have to consider before selecting Row Buffering vs Table Buffering. Are there any guidelines for picking Row Buffering vs Table Buffering?
>
>Thanks
Colin Magee
Team Leader, Systems Development
Metroland Media Group Ltd.
Mississauga, Ontario, Canada
cmagee@metroland.comNever mistake having a career with having a life.