>>>Hi All,
>>> I am selecting records using in clause to select records from a vfp table. I get the following error when I execute the command. SQL expression is to complex. Any work around the in clause limitation.
>>>
>>>Here is my code:
>>>
>>>Local lcwhere
>>>lcWhere = "Mtgid in(1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,370)"
>>>
>>>select * from Batch where &lcWhere into cursor cTemp
>>>
>>>Thanks
>>
>>For VFP6, that's too many options. You'll have to put them into a cursor and do a "WHERE mtgid IN (SELECT mtgid FROM yourcursor)"
>
>
>The maximum number of options for INLIST() is 25. I think it is the same for SQL IN(). You might also try
>WHERE (mtgid IN (first 25) OR mtgid IN (second 25) etc)
That should work, too.