Question

PB 统计问题

做统计窗口时，统计结果为空时不显示数据（理论上应显示为0），望高手指导
统计按钮脚本为：
real a
date(sle_1.text)
if sle_1.text="" then
messagebox("提示","请输入购入时间")
else
select sum(cast(buyprice as decimal(10,2)))
into :a
from bought
where buydate=:sle_1.text;
messagebox("",a)
sle_2.text=string(a)
return
end if

Answer 1

real a
a=0
date(sle_1.text)
if sle_1.text="" then
messagebox("提示","请输入购入时间")
else
select sum(cast(buyprice as decimal(10,2)))
into :a
from bought
where buydate=:sle_1.text;
if (a<>0) then
messagebox("",a)
sle_2.text=string(a)
end if
return
end if