>>John,
>>Reread what I wrote. Any cursors/tables opened within a private session is closed, no matter they are in DE or not.
>>Cetin
>
>Cetin,
>I do respect you experience and am very greatful for all your help over the years so please don't think think I am arguing with you but I spent some time testing this yesterday. The files remain open in the private data session after the form is closed. I am sure it is the way we are doing it.
>
>A Modal form is run at the top of a prg. The form.datasession is totally empty but the form.datasession property = 2.
>
>Everything now happens in procedures called from within the form. If the user selects a menu button to view open invoices we run a SQL and now the tables are open in the private data session.
>
>When we exit the form the default datasession is selected. However, the private datasession that was opened in the form still exists and the tables are still open. I found this by accident when I was opening and locking a file in a procedure called from the form init. If I got out of the form and went back in the file was still locked.
>
>My assumption is that because we are not opening any tables in the datasession that the form is not closing them. But now that I think about it maybe if I try opening one table in the datasession it might close the session.
I wouldn't think it as a destructive one:) OK but anyway watch for a memory leak. It might be an indicator there is something holding a reference.
Cetin