>>Micheal,
>>Thanks for replying.
>>
>>>Hi Kim,
>>>
>>>I can not do anything about VFP changing your where clause, but maybe you could try this instead
>>>
>>>SELECT *;
>>> FROM glass!itmlayer;
>>> WHERE Itmlayer.process IN ("x", "y", "z")
>>>
>>>Maybe VFP will leave this one alone and you should get the same results.
>>>
>>>Hope this helps.
>>
>>My example was just an illustration. I've come across a problem that I'm STILL trying to resolve. Ideally what I'd like is to be able to use the IN clause just as you've stated. However, my values are unknown at design time. Actually this list is to be populated from a multi-select listbox.
>>When I've attempted putting "IN (?lcList)" in my view and running where lcList = '"A","B"' the returned results include only "A" records, NOT "A" or "B".
>>
>>Having failed at this point to get the IN to work correctly I reverted to allowing a set number of list values, hence using the field = ?parm1 OR field = ?parm2, etc.
>>
>>Would you have any ideas why "IN (?lcList)" doesn't work. Or would you have a viable workaround. Up to this date the direct approach or any of my attempted workarounds AREN'T working.
>>
>>Thanks,
>>Kim
>
>Just out of curiosity, have you tried INLIST too?
If I tried INLIST previously I couldn't get it to work then. Just tried it again, building my view with the view designer including an INLIST clause for my field in question and it works GREAT!
Thanks bunches, Kim
Previous
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