The SQL engine in VFP has been changed because it could give wrong results, and in order to be ANSI-SQL compliant. Read about it in help under SET ENGINEBEHAVIOR.

NB! I STRONGLY suggest that you modify your select statements to comply with the updated syntax, or you risk getting WRONG data. You can use different values for SET ENGINEBEHAVIOR, but only do this as a short time "band aid".

>Hello All!
>
>I have a form with this code:
>
>......
>SELECT A.bs,A.val,A.key_,A.otd,A.numb,A.summ_i,A.summ_iv,B.prizn,B.open_date,C.* FROM t_p A LEFT JOIN L_po1 B ;
>ON A.bs+A.val+A.key_+A.otd+A.numb=B.bs+B.val+B.key_+B.otd+B.numb LEFT JOIN L_recli C;
>ON B.kod_client=C.kod_client WHERE A.summ_i>0 AND ;
>(Left(A.bs,3)='423' or Left(A.bs,3)='426' or Left(A.bs,3)='522' or ;
>((A.bs='40806' or A.bs='40809' or A.bs='40812' or A.bs='40813' or A.bs='40814' or A.bs='40815') and B.prizn like '%F_%') ;
> or A.bs in ('40803','40817','40820','47603','47605','52404')) ;
>INTO table SYS(2023)+"\L_dog012" ORDER BY C.kod_client
>.....
>
>When I save this form in VFP6 command work/
>When I save this.form in VFP9 and then run in VFP6
>I have error:Function argument value,type,or count is invalid
>
>I see this sql command many hours an don't understand
>where is my error.
>
>Thanks.