Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
IN clause in Parameterized views
Message
 
À
01/04/1999 18:55:33
Bob Lucas
The WordWare Agency
Alberta, Canada
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00204282
Message ID:
00204603
Vues:
22
>Another alternative is to use multiple parameters (INLIST(, ?p1, ?p2, ?p3, ?p4, ?p5) etc to some reasonable limit. INLIST has a limit on the size of the string anyway. fill all the parameter with a bogus value and replace the few that you need with real values.

25 is the limit, I believe, I bumped into it once. Also INLIST can't be used with the view designer...but it'll work fine if you use something like Erik Moore's Eview application, available here in the UT files...
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform