>Do you have other routines that issue an FLOCK() and then do a bunch of
>processing? Do you use pessimistic buffering? Is someone hitting your
>tables with something other than VFP?
Yes, in the INSERT INTO, I have something like this:
INSERT INTO (IDFIELD,etc.) VALUES (GetNumero('THREAD'),etc.)
where the GetNumero() function is doing a FLOCK() in a TABLE.DBF in order to readjust the next ID value and then return that value here. This is usually a flash.