>>>Ok, here's the deal. I have a form with a grid which holds data from a parameterized view. the view is lited in my DE and opens just fine when the form instantiates, but the base tables that the view is constructed from also open up, because I guess it needs to run the SQL on the tables to get the view definintion. The problem comes when I exit this form. The view closes as it should, but the base tables remain open. Is there a way to make these base tables close when the form is released without having to release them individually. I poked around for some time, but couldn't find a way to close tables except for selecting tables and issueing use to close. It would seem there should be a better way to do this.
>>>
>>>Thanks!!
>>>
>>>John.
>>
>>First of all, you are correct about what is happening with the base tables opening. Check AutoCloseTables in the DE of the form. Is it .T.?
>
>
>Hi Colin,
>
>both close and open are set to .T. in the DE, and the view does close as it should, but base tables insist on sticking around.
>
>thanks
Include base tables in DE, and it will close them.
Edward Pikman
Independent Consultant