Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Accessing another forms private data session
Message
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01245066
Message ID:
01245073
Views:
22
Thanks a lot Naomi. I think that I will be able to share the DS!

>>I have a cursor in the private data session of one form that I would like to be able to access at the startup of another form.
>>
>>I was thinking that I could get a reference to the calling form, get the DataSessionID, save the current DataSessionID, SET DATASESSION to the data session of the other form, query for the data I want, and then switch the data session back.
>>
>>Will this work, or is there a better way?
>
>Few ways.
>
>1) Share DS between forms - if form 2 is a child form of the first form, then this form may use default DS thus it would share main form private DS
>
>2) Pass data using CursorToXML/XMLToCursor - useful for not very big tables
>
>3) Instead of a cursor use the temporary table
>
>4) Check How to pass cursor between two VFP datasessions (without using XML) FAQ #29297
Mike C.
-------
I keep trying to find a life of my own, apart from you.
DC Talk/Charlie Peacock, In the Light.
www.risensystems.com/ra/itlbegin.rm
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform