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.
>>>>
>>>>>
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement