Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Difference with VFP6 and VFP9 interpretations
Message
From
24/08/2007 05:44:34
 
 
To
24/08/2007 04:51:52
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Miscellaneous
Thread ID:
01250111
Message ID:
01250120
Views:
17
Thank you Tore for answer!
But I don't understand what function in my select statement is invalid
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform