>>>When using default data-session,
>>>all under-laying tables of an updatetable view (seleced in DE)
>>>are not released atutomatically with the view when form is closed.
>>>
>>>Is this one of the DE bugs?
>>>(Note that the tables are not opened before opening the view.)
>>>
>>>How do i overcome it?
>>>
>>>Thks.
>>>
>>>Han Wah
>>Han Wah,
>>
>>This is by design. The tables for any sql select statement are left open and always have been. If you want them closed you must close them yourself.
>
>Any tips on how to close all the tables open by the view on form release?
Unless your app design prohibits it, the easiest way (IMHO) is to use private datasessions. A cursor cannot stay open if the datasession it resided in no longer exists (which is what happens when a form witha private datasession is destroyed).
Erik Moore
Clientelligence