Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Tables not closing when form closes

Status
Not open for further replies.

Eguy

Programmer
Dec 22, 2000
566
US
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.
smallbug.gif
 
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: My Crystal Reports web site:
 
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.
smallbug.gif
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top