>
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).
One more little piece of information, in case it makes a difference.
The "culprit" form is based on a class in a VCX file. And the form is opened with the following line:
DO FORM MyForm.SCX NAME oMyForm LINKED NOSHOW
Could the above method of opening the form be the cause of the problem?
"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