Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Locking problem in 8
Message
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00748662
Message ID:
00749203
Views:
25
Ok, thanks for the explanation. Interestingly, it locks even if you do a SQL against the locked table or USE table NOUPDATE.

I appreciate the help.

Dennis

>It's not a bug, it's a feature! :)
>
>VFP8 does a quick check for table corruption every time you USE a table. To do this it needs to lock the header momentarily, to get an accurate count of the number of records.
>
>Of course, that additional locking can cause scalability issues, so the released version contains the command SET TABLEVALIDATE, which allows you to specify whether you want this extra integrity check.
>
>
SET TABLEVALIDATE TO 0   && Don't lock header when USEing a table.
>
>-Tom
>
>[This post is provided AS-IS with no warranties, and confers no rights.]
Previous
Reply
Map
View

Click here to load this message in the networking platform