Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Parametrized view and multiples parameters
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00430842
Message ID:
00431163
Vues:
13
All you need to do is set lcWhere to whatever expression you want. That can be anything that evaluates to a value expression. Some examples:
lcWhere = '(dCreate > tdCreate or empty(tdCreate)'
lcWhere = '((X <= Y and Y > Z) or (A = B and C < A))'
lcWhere = 'x*5+3 > A-2/B'
The point is, it doesn't matter what variables you need in the WHERE clause. They can be completely different every time.

>Hi
>
>But I need establish properties every time for update the data source?
>Anyway, I create a view using eview (UT files!!!) with where like:
>where dCreate>?tdCreate or empty(?tdCreate)"
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform