Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Difference with VFP6 and VFP9 interpretations
Message
From
24/08/2007 04:32:23
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Difference with VFP6 and VFP9 interpretations
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Miscellaneous
Thread ID:
01250111
Message ID:
01250111
Views:
65
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
Map
View

Click here to load this message in the networking platform