I think Tracy suggestion is a good one. However, AFAIK (again) UPDATE SQL (DELETE SQL, etc.) commands don't lock table header, while VFP commands like REPLACE FOR, DELETE FOR, INSERT do. We need to check help on this topic (which commands lock table header/record and which don't).
>Thanks for the info.....!
>
>>
>>You could do that, but if you do, I would put a timer in it manually. Such as:
>>
>>
>>
>>SELECT auditbat
>>
>
>-SNIP -
>
>>
>>
>>How long does it typically take to run that process? Have you tested update times?
>
>
>These processes take less than 30 seconds each....
>
>>
>>Or you could do conditional searches for your records that match your condition and update each record accordingly. That's the approach I usually take and I lock the record before I update it and unlock it again. These are the solutions I've used ONLY when I cannot use buffering for whatever reason.
>
>Yeah... these tables are FREE tables.... so guess I need to use FLOCK and RLOCK
>
>Thanks once again!
>Tommy
If it's not broken, fix it until it is.
My Blog