Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
IN() parameterized Views
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00397490
Message ID:
00397516
Vues:
16
>Can anybody out there help?
>
>MSDN article Q156631 says quite clearly that the IN() filter condition doesn't work! Thats all very well but how do I do a parameterized view for a numbers of customer IDs when I don't know how many I will need to look for?
>
>Has anybody any good ideas of how to get round this one?
>
>Thanks in advance
>Jeremy

From a previous reply of mine:

I have had this problem where you can not parameterize a list of values for the IN or INLIST function. The problem is with character values where each has to be in quotes. You can not submit a character string like "3053", "3051", ..., "4152" . If you know you will never submit X number of items in the list, you could create X parameters in the IN.

IN (?Parm1, ..., ?ParmX)

Then if the user only select X-1 parameters, you would have to make parameter X some value that you must know does not exist. I have never found a way to parameterize a list with a variable number of parameters, at least for a permanent view.

You can build this successfully in SPT.
Mark McCasland
Midlothian, TX USA
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform