Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Public vs Private Datasession
Message
From
15/12/2000 12:33:22
 
 
To
15/12/2000 12:14:22
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00453417
Message ID:
00454051
Views:
27
>This new to me so please bear with me.
>
>What I want to accomplish is have two (or more) forms open which have one or more tables in common with out
>having them them steping on each other (as far as I can tell only one form can update a particular table), that is
>if record pointer(s) moves in form b it should not affect records in any of the other forms. Will private datasession
>do this? For case where called form use same tables as called form and work with a subset of the data I would
>use default datasessions.

This is exactly what private data session will do. The one thing to be aware of is that if you use buffered data, the data is not made available to different data sessions until it's committed to the table using TABLEUPDATE(); it's the same propblem as requerying against a table with data in buffers in the same data session; the requery runs against the table at the time the query or requery is issued.

>
>What about cursors created in one form but used in called form?

It's a matter of the data session - if the called form shares its data session with the parent, then any cursors created by the parent will be avaialble to the called form. If each form has its own data session, then it has its own set of data and aliases in use - you can have two private data session that each have a cursor with the same alias, but that will have their own unique sets of data for their session. If they share a session, then the data pointed to by their alias is the same.
EMail: EdR@edrauh.com
"See, the sun is going down..."
"No, the horizon is moving up!"
- Firesign Theater


NT and Win2K FAQ .. cWashington WSH/ADSI/WMI site
MS WSH site ........... WSH FAQ Site
Wrox Press .............. Win32 Scripting Journal
eSolutions Services, LLC

The Surgeon General has determined that prolonged exposure to the Windows Script Host may be addictive to laboratory mice and codemonkeys
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform