Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL Select from table in different data session
Message
 
À
26/08/1998 11:27:33
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00130093
Message ID:
00130109
Vues:
25
>>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform