The values aren't actually in a series. I'm just using the series to define the problem.
>Why not use BETWEEN(fld1,1, 25)
>>Hi all,
>>Given the code snippet below, this one will not work in VFP8SP1. It will generate the "SQL expression is too complex (Error 1845)" error.
>>
>>close databases all
>>create cursor xxx (fld1 i)
>>select * from xxx ;
>> where fld1 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)
>>
>>
>>I know that this will work in VFP9 but what I'm wondering is that, I can't find any documentation in VFP8SP1 regarding this error. :(
>>
>>Is there a VFP8 runtime fix for this?
ramil
~~ learning to stand still