Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
INLIST in Select
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Network:
Windows 2008 Server
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01396104
Message ID:
01396105
Vues:
93
You're doing it incorrectly.
* It's preferable to use IN operator in a query
...
AND sub_key.sub_key IN (93,97,352,354,355)
...
* or 
...
AND INLIST(sub_key.sub_key,93,97,352,354,355)
...
>I am trying to use inlist for integer values but I keep getting errors saying invalid oprand/mismatch. Is the following type of query valid?
>
>
>select sub_key.sub_key,sub_vendor from sub_key where sub_key.main_keys = 7450 
AND sub_key.sub_key = INLIST(sub_key.sub_key,93,97,352,354,355) into cursor blah
>
>
>thanks
>Nick
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform