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
From
26/05/2006 12:59:20
 
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:
01125328
Views:
24
I was looking at the help on this in VFP and the way it was stated for "BIT VALUE (additive) for 4 is as follows

*** Stright from VFP 9 Help on SET TABLEVALIDATE***
Suppress "File is in use (Error 3)" if table header cannot be locked when opening the table. Requires setting the first bit to validate record count when opening a table.

Note
When opening a table, the USE command attempts to lock the table header only once. If the header is locked, Visual FoxPro performs a strict header check, similar to SET TABLEVALIDATE set to 1. Otherwise, Visual FoxPro suppresses the "File is in use" error and performs a header check in the manner of versions prior to Visual FoxPro 8.0.


So, I was under the impression that any version under vfp 8 has some kind of header checking and that if I set it to 0, that there would be no header checking at all. That's why we went with 4, to make sure it work like it did before.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform