Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
INLIST in Select
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Network:
Windows 2008 Server
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01396104
Message ID:
01396105
Views:
94
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--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform