While this message is addressed to Erik Moore, it really intended for all who have responded to my question on Private DataSessions. First I wish to thank all who have responded. I think the responses have helped. If nothing else the responses indicate the DS are powerful tools and I am about to move into deeper water(?) in VFP. I would like to summaraize what I think I have picked up from the responses and various help files. Please feel free to point out glaring misconceptions.
1. When a form is specified to have a private datasession, the private DS is created when the form loads. Foxpro creates a unique ID for the data session.
2. Any data manipulation occurring within the form is acting on the Private DS. The default session and any other private sessions are unaffected.
3. If for some reason I wish to have a method or procedure manipulate data in a private session, I must pass the Session ID and the set data session to the id and then perform the necessary funtions and reset the data session back to the default.
QUESTION: If I establish a Private DS, what happens if I issue a USE or SQL Select inside the form? Are the tables opened in these commands brought into the Datasession? Or is the Data session limited to the Data Environment?
Gotta quit for now the caffeine is wearing off. Thanks again.
Ken Wardwell