General information
Category:
Coding, syntax & commands
>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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only