Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
OPEN DATABASE xxxxxxx EXCLUSIVE doesn't?
Message
From
16/01/2006 09:15:45
 
 
To
15/01/2006 09:01:56
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01086929
Message ID:
01087130
Views:
17
>It do the following in the Command Window:
OPEN DATABASE mainDBC EXCLUSIVE
and no error is reported.
>- This even thoughI can see mainDBC in the databases dropdown in the VFP toolbar.
>
>The I do:
VALIDATE DATABASE
in the command window.
>The resultant output states:
>"Need EXCLUSIVE writeable access to rebuild structural index."
>
>Why doesn't the EXCLUSIVE clause on the OPEN DATABASE command give an error?
>
>cheers

Hi Jim,

I noticed myself this quiet strange VFP behaiviour.
However, DBC is infact open exclusively or locked in some other way
when you issue command as such.
Trying to open database from another PC wld fail

Perhaps 'validate' needs something 'more exclusive' :)

But if you do ;

set exclusive on
open database ...
validate database ...

Then it works ok!
That is perhaps 'more exclusive'
*****************
Srdjan Djordjevic
Limassol, Cyprus

Free Reporting Framework for VFP9 ;
www.Report-Sculptor.Com
Previous
Reply
Map
View

Click here to load this message in the networking platform