What is the mix of OSes for the file server and workstations?
I seem to remember some locking incompatibility of the server is XP and workstations are lesser. I wonder if this could be similar?
good luck
>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.
>>>>
>>>>>
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only