Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
View simple problem
Message
From
08/11/2000 13:07:04
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00439246
Message ID:
00439297
Views:
29
Nadya:

>
In my code (currently it's a program, lately I may make it to be a form's method) I open a view by use vAllStatConfigs in 0 nodata alias WorkConfig. Then I assign view parameter and requery(). In Data Session now there are 4 tables open: 3 tables, on which view is based and the view itself. My question is: how can I close these tables automatically? When I issue use in WorkConfig, all three underlying tables remain opened...
>

You can do a variation of the following:
Store the names of the table aliases that were in use before your view view was opened in a form property (or whatever) and loop through the work areas in CloseView and close all aliases that are not listed in the form's property. I'm not crazy about this sort of thing but it can work in some situations.

Daniel
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform