Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Changing the SQL property of a View on the fly
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00283275
Message ID:
00283856
Vues:
15
>Wayne:
>
>You don't send any parameters to the View. You build a SQL string from a query form or something similiar, then pass it to a prg that drops the view from the dbc (local) then recreates the view with a the new WHERE clause. In the DE you must close and reopen the tables in order for it to take effect.
>
>It is especially useful in C\S application. The user has complete control over the data brought down from the server.
>
>Charlie

It really sounds like you would be better off using pass through... then you could create your select statement on the fly.


Wayne
Wayne Myers, MCSD
Senior Consultant
Forte' Incorporated
"The only things you can take to heaven are those which you give away" Author Unknown
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform