盒子论坛 v2.1

我用下面的语句在更新dayrep表时当count(servicetimes),sum(servicecount)统计的结果为0时，为什么dayrep表的相应记录的值却不为0，而是空的呢，怎么样才能让这个值显示为0呢！字段servicetimes,servicecount的数据类型为demical类型！
SQLStatement:='update dayrep set(dayservicetimes,dayservicecount,daytotalfee) = ';
      SQLStatement:=SQLStatement+' (select count(servicetimes),sum(servicecount),sum(TOTALFEE) from '+MyTableName;
      SQLStatement:=SQLStatement+' where trim('+MyTableName+'.calledid) = trim(dayrep.calledid)';
      SQLStatement:=SQLStatement+' and servicestarttime > :DateTime1';
      SQLStatement:=SQLStatement+' and servicestarttime < :DateTime2';
      SQLStatement:=SQLStatement+' group by CALLEDID)';
----------------------------------------------
你是我的最爱！

作者：

givemeliu (delphi傻瓜)	★☆☆☆☆	-
	盒子活跃会员

2003/10/13 17:49:15

1楼：

你可以先查寻在判断然后附值；
var sertime,sercount,daytotal:integer;
trySQLStatement:=' (select count(servicetimes)as sertime,sum(servicecount)as sercount,sum(TOTALFEE)as total from '+MyTableName;
      trySQLStatement:=trySQLStatement+' where trim('+MyTableName+'.calledid) = trim(dayrep.calledid)';
      trySQLStatement:=trySQLStatement+' and servicestarttime > :DateTime1';
      trySQLStatement:=trySQLStatement+' and servicestarttime < :DateTime2';
      trySQLStatement:=trySQLStatement+' group by CALLEDID)';
query1.close;
query1.sql.clear;
query1.sql.add(SQLStatement);
query1.open;
if not query1.eof then
begin
sertime:=query1.fieldbyname('sertime').asfloat;
sercount:=query1.fieldbyname('sercount').asfloat;
daytotal:=query1.fieldbyname('total').asfloat;
end;
SQLStatement:='update dayrep set(dayservicetimes,dayservicecount,daytotal
fee) = ';

SQLStatement:=SQLStatement+inttostr(sertime)+','+inttostr(sercount)+','+daytotal

----------------------------------------------
我们共同努力，一切问题都会解决

信息

登陆以后才能回复