VFP 愛用者社區

[jepp]

問題出在 combo 物件上，已解決，謝謝。

請各位幫忙看一下這三段sql語法是否有問題?
程式執行到這邊有時會出現語法錯誤，在相同情況下有時會有時不會。
麻煩各位了，謝謝。
------------------------------------------------------------------------------
if mpay2=1
maa1="eee.e01=tte01 .and. eee.sno=ttsno .and. eee.num=ttnum .and. sod1.ctno=ttctno .and. eee.a01=ma01 .and. eee.qty-eee.fqty>0 .and. eee.cas1=2"
else
maa1="eee.e01=tte01 .and. eee.sno=ttsno .and. eee.num=ttnum .and. sod1.ctno=ttctno .and. eee.a01=ma01 .and. eee.qty1-eee.fqty1>0 .and. eee.cas1=2"
endi
select eee.e01,eee.sno,eee.num,eee.a01,eee.dat,eee.qty,eee.fqty,eee.pric,eee.per,eee.mark1,kind.name as namek,kind.mark as namek2,;
eee.qty1,eee.fqty1,sod1.prna,sod1.desc1,sod1.prna1,sod1.prna2,sod1.prna3,sod1.pano,sod1.var1,sod1.cprna,sod1.cprna1,sod1.cprna2,sod1.cprna3,sod1.ctno;
from kind right outer join sod1;
inner join eee;
on sod1.sno+sod1.num=eee.sno+eee.num;
on kind.pano=sod1.pano;
where &maa1;
order by eee.e01,eee.sno,eee.num;
into cursor tmp

SELECT over1.var,over1.no,over1.dat,over1.qty,over1.pric,over1.qtya,over1.qtyb,;
over1.per,over1.qty1,over1.mark1,over1.a01,over1.a12,over1.fqty,over1.fqty1,;
over1.dat1,over1.var1,aa.name as name1c,over.casa,over1.mark2;
FROM over inner join over1;
left outer JOIN aa;
ON over1.a12=aa.a01;
ON over.var+over.no=over1.var+over1.no;
WHERE over1.e01+over1.sno+over1.num+over1.var=ne01+nsno+nnum+ttvar and over1.a12=ma01 and over1.cas3#1;
ORDER BY over1.no;
into cursor tmps1


SELECT over31.var,over31.no,over31.dat,over31.qty,over31.pric,over31.qtya,over31.qtyb,;
over31.per,over31.qty1,over31.mark1,over31.a01,over31.a12,over31.fqty,over31.fqty1,;
over31.dat1,over31.var1,aa.name as name1c,over.casa,over31.mark2;
FROM over3 inner join over31;
left outer JOIN aa;
ON over31.a12=aa.a01;
ON over3.var+over3.no=over31.var+over31.no;
WHERE over31.e01+over31.sno+over31.num+over31.var=ne01+nsno+nnum+ttvar and over31.a12=ma01 and over31.cas3#1;
ORDER BY over31.no;
into cursor tmps2