Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
FLOCK() in VFP 9 verses VFP 6 (2nd user can't open table
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01058132
Message ID:
01058136
Views:
22
>>In VFP 6 after I USE (open) a table and do an FLOCK() I can still USE the table at another PC.
>>
>>In VFP 9 I can't USE a table from PC 2 after I FLOCK() it at PC 1.
>>
>>I tried USE table SHARED but it made no difference. If the table is open on both PCs I can FLOCK() it from PC 1 and it behaves normally at PC 2. That is I can't do any locks but I can view it.
>>What am I missing?
>>
>>TIA
>
>VFP9 (and VFP8) have a SET TABLEVALIDATE setting that is trying to test the table for corruption. You'll probably need to SET TABLEVALIDATE TO 0 in order to open it the same as VFP6 did.

Fred,
Thanks a million. That was it.
Beer is proof that God loves man, and wants him to be happy. - Benjamin Franklin
John J. Henn
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform