Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Select from table in different data session
Message
 
To
26/08/1998 11:27:33
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00130093
Message ID:
00130109
Views:
24
>>I have a form (lets say form1) that creates a temporary cursor from 3 source tables. Then I have another another form (form2) that needs to see that temporary cursor but not see the three source tables. So if I setup form1 to have a separate data session to hide the source tables, how can I get form2 to see that temp cursor created by form1? Changing how my data sessions are setup is an option if necessary. Any ideas? TIA!

>OIC.
lnId = thisform.datasessionId  && Save sess id
>set datasession to form2.datasessionId  && Change data session
>* Utilize cursor
>set datasession to lnId && Restore session
Cetin

So ok, that gives me access to the cursor, but does not help solve my problem. I need form2 to actually *see* the temp cursor because it needs to run other queries in it's own data session that use the temp cursor created by form1 as a data source. I guess this defeats the purpose of private data sessions and therefore I can not do it?
Roxanne M. Seibert
Independent Consultant, VFP MCP

Code Monkey Like Fritos
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform