>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?
VFP8 uses the inlist() function which can handle up to 24 values.