我对SQL的不熟练,请帮我将以下两句commandtext整合成一句,使得假如临时表list2存在的话,先将它删除,再通过语句select f4,f5,f6,f7,sum(f8) as f20,smu(f9) as f30,sum(f10) as f40 into #list2 from list1 group f4,f5,f6,f7建立新的表。procedure TForm1.BitBtn1Click(Sender: TObject);
begin
F_DM2.ClientDataSet1.Close;
F_DM2.ClientDataSet1.CommandText:='if exists (select * from sysobjects where [name]='#list2' and tybe='U') drop table #list2';
F_DM2.ClientDataSet1.CommandText:='select f4,f5,f6,f7,sum(f8) as f20,smu(f9) as f30,sum(f10) as f40 into #list2 from list1 group f4,f5,f6,f7';
F_DM2.ClientDataSet1.Execute;
F_DM2.ClientDataSet1.Open;
F_DM2.ClientDataSet1.Refresh;
end;
end.
非常感谢!
begin
F_DM2.ClientDataSet1.Close;
F_DM2.ClientDataSet1.CommandText:='if exists (select * from sysobjects where [name]='#list2' and tybe='U') drop table #list2';
F_DM2.ClientDataSet1.CommandText:='select f4,f5,f6,f7,sum(f8) as f20,smu(f9) as f30,sum(f10) as f40 into #list2 from list1 group f4,f5,f6,f7';
F_DM2.ClientDataSet1.Execute;
F_DM2.ClientDataSet1.Open;
F_DM2.ClientDataSet1.Refresh;
end;
end.
非常感谢!
解决方案 »
- 用delphi 编写的串口调试精灵
- DBCHART 如何动态设置它的数据源,X,Y轴?
- blazingfire 还需要问您一个问题
- 晕啊~~~~~帮忙帮忙帮忙帮忙帮忙,在线等!!
- 请bluecoffee1979(远程导弹) 97866(weiLuang) dawnxiao(曙光.net) PaPaCong(小勇) 来领分
- 用Indy的Idhttp,如何使用需要身份验证的代理服务器
- 数据恢复是怎么实现的?能给点提示吗?
- 实际应用问题,请多多发言
- 串口通讯
- delphi在保存文件时,怎么判断是否有同名的文件存在.
- 关于Listview的使用问题!急!!!!急!!!!!!!!
- TIdTCPClient问题
用adoquery最方便了:
adoquery1.close;
adoquery1.sql.text := 'exec('if exists (select * from sysobjects where [name]= :Name and tybe='U') drop table #list2 ') select f4,f5,f6,f7,sum(f8) as f20,smu(f9) as f30,sum(f10) as f40 into #list2 from list1 group f4,f5,f6,f7'
adoquery.execsql;
没有处理引号
不记得CLIENTDATASET能否处理这方面的东西了,好长时间没用了!!! :)
begin
F_DM2.ClientDataSet1.Close;
F_DM2.ClientDataSet1.CommandText:='if exists (select * from sysobjects where [name]='#list2' and tybe='U') drop table #list2';
F_DM2.ClientDataSet1.Execute;
F_DM2.ClientDataSet1.CommandText:='select f4,f5,f6,f7,sum(f8) as f20,smu(f9) as f30,sum(f10) as f40 into #list2 from list1 group f4,f5,f6,f7';
F_DM2.ClientDataSet1.Open;
F_DM2.ClientDataSet1.Refresh;
end;
end.
改成这样,行不行?
出错提示:Constant expression expected
Missing operator or semicolon
Statement expected,but expression of type 'String' found 请高手继续指点。