Hi Mahmood,
I try your code with VFP9 and all is well. No error.
I don't know where is the problem.
>Hi All,
> I am using the simple select statement and getting the following error:
>
>Error is SQL expression is to complex
>
>my select is
>
>SELECT Regno from Test group by Regno order by Regno ;
>Where Regno not in(12,41,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,7012,59,60,61,62,63,64,65,66,67)
>
>Any Ideas?
>
>Thanks
_______________________________________________________________
Testing displays the presence, not the absence of bugs.
If a software application has to be designed, it has to be designed correctly!
_______________________________________________________________
Vladimir Zografski
Systems Analyst
