General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Difference with VFP6 and VFP9 interpretations
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.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only