Tables not closing when form closes

[Eguy]

I am developing a form in VFP 8. In the data environment are 3 tables and 2 views. AutoOpen and AutoClose are both set to TRUE.

While debugging I noticed that when the form closes the 3 tables close as expected. However the 2 tables that the views are based on show as open in the data session window.

Now I can easily fix this by issuing USE IN SELECT(name) during the unload, but I wonder if I'm just not just missing something obvious here. Anyone seen this behavior??

TIA
Ed

Please let me know if the suggestion(s) I provide are helpful to you.
Sometimes you're the windshield... Sometimes you're the bug.

 

[Mike Lewis]

Ed,

This is normal behaviour. In general, when you close a (local) view, the underlying table will remain open. You have to close it explicitly, which is exactly what you are doing.

Alternatively, if the form has a private data session, all the tables and views will be closed automaticaly when the form closes.

Mike


Mike Lewis
Edinburgh, Scotland

My Visual Foxpro web site:

http://www.ml-consult.demon.co.uk

My Crystal Reports web site:

http://www.ml-crystal.com

 

[Eguy]

Thanks Mike.

I thought that would be the case, but I wanted a second opinion.

Thanks again and Happy Holidays from this side of the pond!

Ed




Please let me know if the suggestion(s) I provide are helpful to you.
Sometimes you're the windshield... Sometimes you're the bug.