I think its sad that I have to enclose APPEND BLANK or INSERT in a TRY/CATCH block. I just had 2 of the 5 yearly occurences happened in the past 2 nights. I am looking forward to it happening again tonight when most of the processes will run. Incidentally, these recent occurences coincided with a hardware and OS (2000-2003) upgrades.
I've always had faith in VFP to manage INSERTs for me. I guess, this isn't going to be the case anymore...
>No. It locks header as well because the row count has to be updated.
>
>>Thank you for the feedback. Question, will using APPEND BLANK instead fix this?
>>
>>>The INSERT INTO command briefly locks the table header. If 2 inserts happen at the same time, you'll get error 108. Also some commands, like DELETE FOR/WHILE, REPLACE FOR/WHILE look the table whick could cause a similar result.
>>>
>>>>
ramil
~~ learning to stand still