Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Reading from a Table in an other Datasession
Message
From
11/01/2000 19:04:46
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00316553
Message ID:
00316591
Views:
12
>If i create a cursor when i start my program, that cursor creates in the default data session (1). The i opened a form with private datesassion and now the active datasession is (2). When i refer to my table as mytableinsession1.field=xx the system tells me that this table doesn't exist. If i change the datasession with Set Datasession to 1, I loose the bound in the controls bouding to datasession 2 tables.

Usually, the need to use SET DATASESSION points to a design deficiency. If you are using private datasessions, and need a value from a table in another datasession, that value should have been passed with a parameter, or should be retrieved by an object that lives in that table's datasession. Otherwise, why are the datasessions private?
Erik Moore
Clientelligence
Previous
Reply
Map
View

Click here to load this message in the networking platform