>I have been experiencing the
>
>BUG: REQUERY() Problem with Private Datasessions Sharing a Table
>
>as described in the MS Knowledge base ID#: Q169102
>
>I'm trying to track down where i've gone wrong and and using a view two different times on the same table from two different data sessions.
>
>How can I get the status of all datasessions?
>
>When I do a set command I can only see my default(1) and a single private(2) data session. What happens when a form with a private data session calls another form with another private data session? Can't I see what the status of the original private data session is? Ie: What was opened there?
>
>Thanx,
>
>Joe Pirola

Joe, If you're running under VFP (not a compiled EXE or APP) you can see ALL the datasessions by going to the Windows/Datasession menu. You can move back and forth between datasessions and forms, checking the active record, relations, etc. This is VERY useful along with the debugger information.

Second, each datasession has a number. The default is 1, the next private DS is 2, etc. There is a SET DATASESSION TO n command which will set one form's DS to another, or it can be used to check data in another DS.

HTH
Barbara