Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
INSERT INTO causes File is in use error
Message
 
To
22/12/1998 12:55:55
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
00169703
Message ID:
00169740
Views:
17
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
Previous
Reply
Map
View

Click here to load this message in the networking platform