请指教:我的sql语句比如"select sum(步骤) as heji from table1",为什么每次运行都显示"qry1:field[编号]not found",我看论坛里以前类似的问题,有人说是字段里面有空值,但是我测试的时候就一条数据,肯定没空值,而就算把sql语句改成"select isnull(sum(步骤),0) as heji from table1",还是同样的错误,我的步骤字段为number类型的
...全文
14212打赏收藏
关于delphi的sum和max
请指教:我的sql语句比如"select sum(步骤) as heji from table1",为什么每次运行都显示"qry1:field[编号]not found",我看论坛里以前类似的问题,有人说是字段里面有空值,但是我测试的时候就一条数据,肯定没空值,而就算把sql语句改成"select isnull(sum(步骤),0) as heji from table1",还是同样的错误,我的步骤字段为number类型的
[Quote=引用 7 楼 powerguiyu 的回复:]
var sqlstring:string;
begin
sqlstring:='select sum(步骤) as heji from caozuopiao';
with qry1 do
begin
qry1.close;
qry1.sql.clear;
qry1.sql.add(sqlstring);
qry1.open;
end;
edit1.text:=inttostr(qry1.fieldbyname('heji').asinteger)
end;
var sqlstring:string;
begin
sqlstring:='select sum(步骤) as heji from caozuopiao';
with qry1 do
begin
qry1.close;
qry1.sql.clear;
qry1.sql.add(sqlstring);
qry1.open;
end;
edit1.text:=inttostr(qry1.fieldbyname('heji').asinteger)
end;