Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Use Again and Again in different data session
Message
From
11/07/2011 11:48:53
 
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Network:
Windows XP
Database:
MS SQL Server
Miscellaneous
Thread ID:
01517859
Message ID:
01517875
Views:
66
This message has been marked as a message which has helped to the initial question of the thread.
People often miss one important detail, shared access to the DBC. This is common:

USE SomeTable IN 0 SHARED

But it only opens the table shared, not the DBC. There are two solutions

SET EXCLUSIVE OFF before any file access

or

OPEN DATABASE SomeDBC SHARED before any other file access


>When a table is open in another datasession and another program attempts to :
>
use sometable again in 0
>The Fox growls loudly. Since the current program cannot change datasessions because it depends on other open tables in the current session and it cannot forcibly close the table in the other data session what is the programmer to do? what would you do?
>
>Thanks
>
>Glenn
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer
Previous
Reply
Map
View

Click here to load this message in the networking platform