Query返回多个结果,需要直接利用时: Query.First; for i:=0 to Query.RecordCount-1 do begin ShowMEssage(VarToStr(Query['FIELD'])); Query.Next; end;Query返回一个结果,需要直接利用时:VAR I:INetger; begin with query1 do begin sql.clear; sql.add('select count (*) as ii from tablename '); open; end; i:=query1.fieldbyname('ii').asinteger;
如果是想求那个字段的合计可以这样'select sum(ii) from (select count (*) as ii from tablename)'如果是其它类型字段,比如varchar,那就循环query,然后把每个字段值连接起来
for i:=0 to Query.RecordCount-1 do
begin
ShowMEssage(VarToStr(Query['FIELD']));
Query.Next;
end;Query返回一个结果,需要直接利用时:VAR I:INetger; begin with query1 do begin sql.clear; sql.add('select count (*) as ii from tablename '); open; end; i:=query1.fieldbyname('ii').asinteger;