query1.close;
query1.sql.clear;
query1.sql.add('select distinct xinghao as 型号,dianliu as 电流,zhuguan as 类型,');
query1.sql.add('sum(shuliang) as 数量,(sum(shuliang)-sum(uhege)) as 合格数,round(((sum(shuliang)-sum(uhege))/sum(shuliang))*100,2) as 合格率,');
query1.sql.add('sum(iif(jyriqi="'+edit2.Text+'"'+',shuliang,0)) as 当日数,');
// query1.sql.add('(sum(shuliang)-sum(uhege)) as 当日合格数 ,');
query1.sql.add('sum(qidong) as 起动,sum(qiandong) as 潜动,');
query1.sql.add('sum(cos10600) as cos10600,sum(cos10400) as cos10400,sum(cos10100) as cos10100,') ;
query1.sql.add('sum(cos10010) as cos10010,sum(cos10005) as cos10005,');
query1.sql.add('sum(cos05600) as cos05600,sum(cos05400) as cos05400,');
query1.sql.add('sum(cos05100) as cos05100,sum(cos05020) as cos05020,sum(cos05010) as cos05010');
query1.sql.add(' from jxjyyuan where 1=1');
if edit1.text<>'' then
begin
query1.sql.add(' and jyriqi>="'+edit1.Text+'"');
end;
if edit2.text<>'' then
begin
query1.sql.add(' and jyriqi<="'+edit2.Text+'"');
end;
query1.sql.add(' group by xinghao,dianliu,zhuguan');
query1.sql.add('');
query1.open;
query1.sql.clear;
query1.sql.add('select distinct xinghao as 型号,dianliu as 电流,zhuguan as 类型,');
query1.sql.add('sum(shuliang) as 数量,(sum(shuliang)-sum(uhege)) as 合格数,round(((sum(shuliang)-sum(uhege))/sum(shuliang))*100,2) as 合格率,');
query1.sql.add('sum(iif(jyriqi="'+edit2.Text+'"'+',shuliang,0)) as 当日数,');
// query1.sql.add('(sum(shuliang)-sum(uhege)) as 当日合格数 ,');
query1.sql.add('sum(qidong) as 起动,sum(qiandong) as 潜动,');
query1.sql.add('sum(cos10600) as cos10600,sum(cos10400) as cos10400,sum(cos10100) as cos10100,') ;
query1.sql.add('sum(cos10010) as cos10010,sum(cos10005) as cos10005,');
query1.sql.add('sum(cos05600) as cos05600,sum(cos05400) as cos05400,');
query1.sql.add('sum(cos05100) as cos05100,sum(cos05020) as cos05020,sum(cos05010) as cos05010');
query1.sql.add(' from jxjyyuan where 1=1');
if edit1.text<>'' then
begin
query1.sql.add(' and jyriqi>="'+edit1.Text+'"');
end;
if edit2.text<>'' then
begin
query1.sql.add(' and jyriqi<="'+edit2.Text+'"');
end;
query1.sql.add(' group by xinghao,dianliu,zhuguan');
query1.sql.add('');
query1.open;
解决方案 »
- 我现在想实现如下目的,请帮忙出出主意如何实现好。多客户端相互交换数据
- 巢状数据实现Master/detail的问题
- 如何删除一条纪录?
- http://Netbroad.NET/vod/user/reg.jsp?upname=silyangel
- delphi7 mysql问题
- 如何对*.txt(文本文件)进行操作!!!!有急用!!!谢谢诸位老大啊!!!
- 谁能帮我将这两行代码转换成Delphi的?!
- 能否变颜色?Application.MessageBox('对不起,您无权进入此系统!!', '系统提示', MB_OK) ;
- $ 300 -- 有没有人用过条形码打印控件TBarCode ? 他一定要有Delphi 开着才能运行(未注册!)
- 100分求救:MIDAS"无法创建终结点"????
- 一个打印问题,打印高手请进!!!100分谢谢!!!
- 如何同步?高分急救
query1.sql.add(' and jyriqi<='+''''+edit2.Text+''''+')';
memo1.lines.Add(query1.sql.text);
query1.open;
然后在BDE Exporer/SQL anylizer/SQL plus里运行通过再说!
真懒!!
我爱Delphi!
SELECT xinghao, dianliu, SUM(iif(jyriqi = '2002-9-17', shuliang, 0) AS shuliang
FROM jxshenhe
也是出现同样的问题,'='在SQL中能不能用?
(iif(jyriqi = '2002-9-17', shuliang, 0) 你的括号怎么不配对呀?
将日期用formatdatetime格式化试试
回复人: l_xiaofeng(流水不腐) ( ) 信誉:96 2002-9-19 17:12:40 得分:5
同意 Black(小熊) 在DELPHI和DELPHI中的SQL中不建议使用双引,或者杜绝使用.
他得5分,我得2分 ??????????????????????