Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
INSERT INTO causes File is in use error
Message
 
À
22/12/1998 12:55:55
Information générale
Forum:
Visual FoxPro
Catégorie:
Problèmes
Divers
Thread ID:
00169703
Message ID:
00169740
Vues:
23
Hi Sylvain,

>> VFP need to lock the header of the table a fraction of a second when adding new record. If another user try to insert a record while another user as a lock on the header, you get a error message.
2 suggestions:
- Turn on record/table buffering and check the result of TableUpdate() (my preffered choice)
- Issue a RLock(0) before inserting the new record and release it afterward. RLock(0) will lock the header of the table>>
I will try buffering (and Ed's idea on SET REPROCESS TO AUTOMATIC).

Thanks!

Vern
Vern
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform