with query1.sql do
begin
clear;
add('select count(*) as 总数 from mytable');
end;
query1.open;
showmessage(query1.fieldbyname('总数').asstring);
begin
clear;
add('select count(*) as 总数 from mytable');
end;
query1.open;
showmessage(query1.fieldbyname('总数').asstring);
i:integer;
with query1 do
begin
close;
sql.clear;
sql.add(' select count(*) from tablename ');
open;
i:=fields[0].asinteger;
end;