in most cases I think the second would be better as ou can handle conflicts etc. for each record in turn Arnon > >Hi all, > >Here, our Forms usually need to save changes to more than one Table and >also to multiple records into the same Table. So, we've decided to use >Optimistic Table Buffering. > >Now the question is, when saving changes, what is more appropriate: > >A- For each table issue a TABLEUPDATE with the first parameter set to "all >records" (.T.) > >B- For each table, look for each record modified (using GETNEXTMODIFIED), >then issue a TABLEUPDATE with the first parameter set to "current record" >(.F.) > >Any idea about this? (condidering performance and implicit LOCKs issued by >the TABLEUPDATE command...) > >Thanks in advance! > >Renato > >