>>>IN is for use with subqueries. Use INLIST or $ for lists of items...
>>
>>Does it mean that "in (item1, item2, item3)" is not pure SQL? I've used that instead of InList() just because I'm trying to avoid Fox's internals in SQL - though it may be a long time before I stumble over FoxSQL vs RealSQL compatibility issues.
>
>No, I think IN is really supposed to work for lists of items, and is a more standard SQL way than INLIST or $ - it just doesn't work in vfp yet :)
It works in VFP as it did ever since FP2.0, but it doesn't support a list parameter for parametrized view. I guess it would support a "where item in (?lcItem1, ?lcItem2, ?lcItem3)", but that's not that nice and easy - why would I want to have exactly three items every time, or fill the extra ones with dummy values? Subquery is much better for all the situations that crossed my mind while I was at this.