> > Are there still advantages to record/file locking or is buffering > sufficient? > > My primary concern regards system counter fields that are being stepped > by mutiple users, probably at the same time (trans. id, etc). > > Will buffering do it? Will a loop using TABLEUPDATE() work? Am I > missing something? > > Matt Maybe I can answer myself. Will this be safe?... and will it work? ----- ON ERROR DO UpdateError WITH ERROR(), lcMyErrorProc llagain = .T. IF !TABLEUPDATE() DO WHILE llagain ROLLBACK {update record code} llagain = !TABLEUPDATE() ENDDO ENDIF ------ buffering is pessimistic row (table is only one record) UpdateError catches 1585 and 1595 or executes lcMyErrorProc