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?