dm 的类型??query1.sql.Add('select sum(2701),sum(2702),sum(2703),sum(2704),sum(2705),sum(2706),sum(2707),sum(2708),sum(2709) from temcpk where dm <>"0027001"');query2.sql.Add('select 2701,2702,2703,2704,2705,2706,2707,2708,2709 from temcpk where dm ="0027001"');??是不是2701,2702,2703,2704,2705,2706,2707,2708,2709 都是字段名??
能不能把表的各字段给出??
能不能把表的各字段给出??
解决方案 »
- 通过idhttp或得页面,如何将其生成图片?求教!
- 一个数据库问题~~~,高手请进~~~(在线等回答,高分相送)
- 怎样才能使报表的Title(表的标题)在每一页打印都出现?
- 多表查询小问题
- 如何用Installshield 打包Web应用程序
- 请各位高手邦忙!!!一个delphi7与mysql的问题
- 看过李维《delphi5。x分布式多层应用 系统篇》的大虾请进
- delphi能否用来开发实时性很强的与硬件打交道的程序???计算的精度够不够??
- delphi XE 开发腾讯通插件,如何获取当前登陆用户信息?
- 都是win me惹的祸,我的文件莫名其妙就找不到了...
- 请问,我的资源文件中有一个.exe文件,我怎么在程序中调用这个.exe文件
- 紧急关于一个类同时有多个实例的问题?
query1.sql.Add('select sum(2701) as a1,sum(2702) as a2,sum(2703) as a3,sum(2704) as a4,sum(2705) as a5,sum(2706) as a6,sum(2707) as a7,sum(2708) as a8,sum(2709) as a9 from temcpk where dm <>"0027001"');
query1.open;query2.Close; //校验
query2.SQL.Clear;
query2.sql.Add('select 2701,2702,2703,2704,2705,2706,2707,2708,2709 from temcpk where dm ="0027001"');if trim(query1.filedbyname('a1').asstring)=trim(query2.fieldbyname('2701').asstring) then
.......
.......
if trim(query1.filedbyname('a1').asstring)=trim(query2.fieldbyname
应为:if trim(query1.fieldbyname('a1').asstring)=trim(query2.fieldbyname
相信楼主看出来了,在拼写正确的情况下,:)
我的不会,
你的是什么数据库??dm类型A,2701-2709为$??
var:s:real;
s:=0;
if query1.fieldbname('dm').value<>'0027001'
begin
while not query1.eof do
begin
s:=s+query1.fieldbyname('2701').asfloat;
.......................('2702')........
query1.next;
end;
if s=trim(query2.fieldbyname('2701').asstring) then
................
else
...............