Why do views leave open tables behind?

Greetings!

When I open a view and then look in the Data Session window, I see
workspaces for the view and for each table the view uses. When I select the
workarea that is using the view and enter the USE command by itself to close
the view, the view obediently disappears from the data session window, but
the tables remain open. Is there a reason for this, and how can I close the
tables associated with a view when I don't need the view any more?

Thanks very much!

Rob Richardson

Fred
Thu May 20 09:51:05 CDT 2004

That's just the way views work. If you form made use of a private
datasession, when the form closes, it would close all open tables and views
automatically.

If you really need to close the tables, you can loop through the array
created by AUSED() and close the tables individually, but you'd have to know
whethter the table was open for some other reason, and not just opened by
the view.

Fred
Microsoft VIsual FoxPro MVP


"Rob Richardson" <notreally@n2net.net> wrote in message
news:uA2sGmmPEHA.3452@TK2MSFTNGP10.phx.gbl...
> Greetings!
>
> When I open a view and then look in the Data Session window, I see
> workspaces for the view and for each table the view uses. When I select
the
> workarea that is using the view and enter the USE command by itself to
close
> the view, the view obediently disappears from the data session window, but
> the tables remain open. Is there a reason for this, and how can I close
the
> tables associated with a view when I don't need the view any more?
>
> Thanks very much!
>
> Rob Richardson
>
>