>>>
No. The problem was that I was not closing this free table in a form that was using private datasession. So, there was no way I could "close" this table afterward. That is, once the form was released I was stuck.>>>
>>>Hmmm. This makes no sense to me. The data environment's CloseTables() method fires before the form is released so this should not be an issue.
>>>
>>>Something else is going on here.
>>
>>I tracked the problem to the following:
>>If I place the line:
>>
>>use in select("MyTableAlias")
>>
>>right before I call thisform.release() (in Exit Button Click() method), then the table can be opened exclusive later in the application. If I comment this line (Use in...), the table will not open exclusively (error 3).
>
>
>Correct. A table already open cannot be "USED AGAIN" and change the exclusive status. It must be opened just once only to set EXCLUSIVE use.
>
Fred,
The problem or the issue was that it is believed (at least others said so) that when you close a form that has a private data session, all tables opened in this form should be closed. But, what happened is unless I explicitly closed the table, it remained open.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham