Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Record in use and File in use errors
Message
 
 
To
16/07/2006 19:05:33
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 6
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01136694
Message ID:
01136834
Views:
9
Hi John,

It's not a SET EXCLUSIVE issue because you can have tables opened in both computers.

Try next:

1) Open VFP, start your APP
2) Open a second instance of VFP in the same computer, start your APP

Try now the situation making that error, does it happens now? I Tested similiar situation you have within same computer and two VFP instance -> no error.

Also you may have RLOCK() somewhere locking the record you are trying to deleted. You can test it as follows: just before deleting a record in the second PC (and having an error) suspend the APP in the first PC and give UNLOCK ALL command in that PC then continue to delete in the second PC, do you have still an error?

AT
Previous
Reply
Map
View

Click here to load this message in the networking platform