Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
...where field in ?(lcList)
Message
 
À
09/09/1998 16:10:12
Dragan Nedeljkovich (En ligne)
Now officially retired
Zrenjanin, Serbia
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00134774
Message ID:
00134956
Vues:
9
>Is it possible to have a parametrized view defined like this:
>
>create sql view ndd as select * from ..\nalog\nd where nalog in (?lcspisak)
>
>lcspisak=[000005, 000004]
>use ndd
>
>It gives me only the records where nalog="000005", but none where it's "000004". Has anybody done this properly? Or is it impossible altogether. I've tried stuffing an array for lcSpisak, but it uses only the first element. I've tried several combinations, but none seems to work, except macro substitution, which kind of defeats the whole idea of parametrized views.

IN is for use with subqueries. Use INLIST or $ for lists of items...
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform