General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only