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