>I've noted the glaring LACK of information and concrete examples of how to effectively use the new Session Class that comes with SP3. The VFP documentation is, shall we say, sparse.
>
>I understand the principle that the Session class gives us the equivalent of a form's private data session without the form. But there must be *many* creative ways to actually implement this powerful new tool.
>
>How about a lively, in-depth and practical discussion of tips, tricks, and how-to's? How about in COM and especially MTS components? Suggestions for building this thing into your personal framework? Subclassing approaches? Wrapping existing code?
>
>Everyone is welcome -- No suggestions turned away!
I use it to create my initial
shared connection to an Oracle database. Once the user logs in, I have captured their User ID and password to pass to Oracle, open a dummy remote view based on Oracle's DUAL table [used when you only need to return 1 row and are not selecting from a table. e.g., Select SYSDATE From Dual].
Now I can open any other remote view using a shared connection regardless of DS. My dummy view is also
protected because it is not in the default DS. and I do not have the overhead of a form DS.
I also retrieve the connection handle of this view to use in SPT.
Mark McCasland
Midlothian, TX USA