Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Use Again and Again in different data session
Message
From
12/07/2011 10:47:16
Mike Yearwood
Toronto, Ontario, Canada
 
 
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:
01517963
Views:
63
>Mmmmm. I do have the table open in DS1 but my form is running in a private DS. The test I just performed showed DS9. something smells fishy here!
>
>Aha! the table was used EXCL in the other DS.
>
>Thanks
>
>
>
>>The error means that table is already open in the same datasession.
>>
>>>
>>>The table is open in the default datasession and another program in another datasession is attempting
>>>
use sometable again alias "sometable"
>>>Error 3
>>>File is in use
>>>

In addition to what the others have said, opening the tables in the default data session, improves performance of subsequent use agains in private data session forms and in SQL queries etc.
Previous
Reply
Map
View

Click here to load this message in the networking platform