Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Creating Views on the fly
Message
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Creating Views on the fly
Divers
Thread ID:
00396744
Message ID:
00396744
Vues:
38
Hi everyone,

One of my application currently uses predefined hidden filter technique. I think, that it would be better to use view instead. Threfore my question is: how can I create view on the fly? I pass TableName as a parameter, then I have to find owning database, open it, set it to be current and then create a view, right? I also have to delete this view programmatically in Form.Destroy method. Could you please give me a little help here? Also am I right in my assumption, that view should be faster, than filtered tables (I want to create a view based on one table with where equals filter condition)?

Thanks in advance.
If it's not broken, fix it until it is.


My Blog
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform