Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Table is in use by another user
Message
De
22/08/2002 14:35:22
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00692079
Message ID:
00692599
Vues:
18
>Hi Mark,
>
>INSERT command places lock on the table header for duration of the insert. If table or it's header is locked by another user, you'll get Error 108 'File is in use by another user'. You can use SET REPROCESS TO command to control how long VFP tries to lock record after unsuccessful locking attempt.
>If table open exclusively by somebody else, you wouldn't be able open it and would get Error 1705 'File access is denied'.
>
>>I have a program that does an extensive INSERT (going thru a loop) INTO a table on network. That table is opened before the loop so there is no way someone opens that table exclusively. Once in a while I am getting a message in a question. Any idea?
>>
Thanks
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform