Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to use tables in Private Datasession ?
Message
From
06/06/2012 08:17:25
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
 
To
06/06/2012 00:10:34
Yim Ming Sun Derek
Spacious Design Consultant
Hong Kong, Hong Kong
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01545423
Message ID:
01545449
Views:
50
Likes (1)
It doesn't really matter how you open them (you can also use Form.Load()): if the datasession is private, they should be opened and closed independently in both forms, almost as if each form were an independent user. Closing the table in one form (or closing the form, which closes the tables automatically in a private datasession) shouldn't affect the other form. Something is going wrong, but I don't know what. Perhaps the form is actually changed to the default datasession, for example. This may require some debugging.

>Hi
>I have 2 Modeless forms which set the datasession property to 2 (Private),
>Both of these 2 forms use the same customer file (cusmas.dbf),
>but I find that when I close one form, the customer file also closed in another form.
>
>How can I open and access the same file separately ?
>
>I just only write the open file coding in the DataEnvironment INIT event of the form as follow.
>
>
>USE CUSMAS IN 0 ALIAS cusmas 
>SET ORDER TO CUSNO
>
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform