Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Shared option in USE command
Message
From
23/09/2014 13:49:20
 
 
To
23/09/2014 13:32:09
Antonio Lopes (Online)
BookMARC
Coimbra, Portugal
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:
01608101
Views:
45
That's a good point. If you simply USE table, the DBC will be opened with it. However, a good practice is to OPEN DATABASE x SHARED before any USE statements.

>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.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer
Previous
Reply
Map
View

Click here to load this message in the networking platform