>>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.

Putting private data session aside ,

In some of my work in default data session, I observed that the DE did auto-close the under-laying tables of a view !

Why does this happens? OR base on what the DE do auto-closing to the under-laying table of a view?