Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SELECT ... WHERE process in ?lcProcess
Message
From
15/08/1996 09:30:00
Mark Stanton
The New Software Company Ltd.
Watford, United Kingdom
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00005765
Message ID:
00005778
Views:
37
>It's the fact that, if you supply, say "A", "B" when you do a USE view and VFP prompts you for ?lcProcess, only those values where the 'process' field equals "A" are returned. Also, how would you supply two values to a variable programmatically?

I suspect this is due to a misunderstanding of the "IN" clause, one which I'd also made.
It must be that "IN" is for comparing fields with a field in a subselect
( eg "WHERE xyz IN (SELECT field FROM yourtable)"
rather than a real list (which only exists in that form in the "INLIST" function.

Try using "WHERE INLIST( yourfield, "A","B")
It's not even too slow <g>

Mark
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform