Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL and underlying tables
Message
From
30/11/1999 21:25:26
 
 
To
30/11/1999 20:53:17
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00297198
Message ID:
00297202
Views:
27
>Hello all,
>
>I have a form that creates a private data session and opens a couple of views, in the data environment of the form I only include the views...when the forms runs it triggers another form with a private data session and a couple of views....the second form seems to get a file in use error since one of its views uses the same underlying table as the first screen.....Each view opens its underlying tables in the data session and appears to do that in exclusive mode....I have set exclusive off however when the view runs the tables that it opens do not seem to heed this.....where am i going wrong.....thanks
>
>pvava

Where did you set exclusive off? Since you're using private datasessions, you must have it set off in your BeforeOpenTables method of your dataenvironment on each form. Exclusive must be off BEFORE the tables are actually opened.
Fred
Microsoft Visual FoxPro MVP

foxcentral.net
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform