VFP 愛用者社區

[cmj8992004]

我有個 sql 的統計語句,統計1~7月分的數據及7月份當月的數據

tsdate = '950101'
sdate = '950701'
edate = '950731'

select custpay3.code,;
sum(iif(between(custpay3.date,sdate,edate),iif(custpay4.money4>0,custpay4.money4,0),0)) as ptotmoneyx,;
sum(iif(between(custpay3.date,sdate,edate),iif(custpay4.qty>0,custpay4.qty,0),0)) as ptotqtyx,;
sum(iif(between(custpay3.date,sdate,edate),iif(custpay4.qty>0,custpay4.qty*custpay4.wet,0),0)) as ptotwetx,;
sum(iif(between(custpay3.date,sdate,edate),iif(custpay4.qty<0,custpay4.qty,0),0)) as mtotqtyx,;
sum(iif(between(custpay3.date,sdate,edate),iif(custpay4.qty<0,custpay4.qty*custpay4.wet,0),0)) as mtotwetx,;
sum(iif(between(custpay3.date,sdate,edate),iif(custpay4.money4<0,custpay4.money4,0),0)) as mtotmoneyx ,;
sum(iif(custpay4.money4>0,custpay4.money4,0)) as ptotmoney,;
sum(iif(custpay4.qty>0,custpay4.qty,0)) as ptotqty,;
sum(iif(custpay4.qty>0,custpay4.qty*custpay4.wet,0)) as ptotwet,;
sum(iif(custpay4.money4<0,custpay4.money4,0)) as mtotmoney,;
sum(iif(custpay4.qty<0,custpay4.qty,0)) as mtotqty,;
sum(iif(custpay4.qty<0,custpay4.qty*custpay4.wet,0)) as mtotwet ;
from custpay3 inner join custpay4 on custpay3.number=custpay4.number inner join cargo1 on custpay3.number=str(cargo1.number,8 ) ;
where custpay3.date between '&tsdate' and '&edate' and cargo1.china order by custpay3.code group by custpay3.code into cursor custpaycn


其中欄位 custpay4.wet 有小數點,但經 sql 統計後臨時表的欄位 ptotwet,mtotwet是正確的,ptotwetx,mtotwetx 確沒有小數點.

是我的 sql 語法錯了,還是 VFP 9有 BUG.

[garfield]

是不了解vfp特性, 不是bug
將0 改成 0.0000 則會有4位小數

[cmj8992004]

原來如此,謝謝了.