Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement