Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Shared option in USE command
Message
From
23/09/2014 13:32:09
 
 
To
23/09/2014 10:04:00
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows 8
Network:
Windows 2008 Server
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01608037
Message ID:
01608089
Views:
45
>You have to be careful with this as the database could have been opened exclusive. In this case, if I remember correctly, the table is opened EXCLUSIVE also.
>
>>USE .. SHARED opens a table in non-exclusive mode, even if SET EXCLUSIVE is ON.

You remember correctly and Cyrus should be aware of the point you've made. Nevertheless, table and database containers are at different levels. When the database is opened excusively, it's the access to the container that is denied and that does not look like Cyrus' scenario: if a database container is openend exclusively there is no way another user or process can open any of its objects as shared resources.

And going back to the first question Cyrus posted, what applies to tables also applies to databases: even if SET EXCLUSIVE is ON, you can OPEN DATABASE x SHARED and it will be opened in non-exclusive mode.
----------------------------------
António Tavares Lopes
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform