>>I have a form with a private data environment. I need to SELECT a free table that was "USED" earlier in the program. Since it is not a part of the data environment, it won't let me select it. It is a 2.6 table, so I can't add it to a Database. I don't want to add it to the DE as a free table because I don't want the location hard coded. How can I either select this free table or add it programatically to the DE.
>>
>>ED
>
>Ed, a free table should respond to USE and SELECT the same as a table in the DBC - I use them regularly. Check in your Datasession list (Window/Datasession menus) and look at the DS in question. If you don't see it, then start checking code for where it was closed (in my case it's usually a USE without the IN 0 clause) or whether it was called in the default datasession by mistake.
>
>HTH
>Barbara

Barbara:

I opened the table up outside of the form, so when I entered the form I couldn't select it. I could, however open it again in the Ini() method of the form, as you suggested. A strange thing though, relations that I set up visually and used to work fine have started acting strange when I changed the DE to Private. Is something that I missed when I changed the DE to private?

Taanks
Ed