var a : integer; begin with myQuery do begin close; Sql.Clear; Sql.Add('select sum(a8) as aaaa from table1 where...' ); Open a := FieldByName('aaaa').AsInteger; Close; end; edn;
假如我就在下面的语句中实现求A8的和,应该怎么加入语句呢? querysz.sql.clear; querysz.SQL.add('select * from xhsz where '); querysz.SQL.add(' sztype='+'"'+querysztype['sztype']+'"'); querysz.open;
下面的语句是查询语句,我想在这个查询语句中加入一个求A8和的SQL,应该怎么加? querysz.sql.clear; querysz.SQL.add('select * from xhsz where '); querysz.SQL.add(' sztype='+'"'+querysztype['sztype']+'"'); querysz.open;
按照下面的求和方法是行的,但我需要将结果显示到2位小数(即下面a的值不能为整数,应该是有2位小数的数值),应该怎么做呢? var a : integer; begin with myQuery do begin close; Sql.Clear; Sql.Add('select sum(a8) as aaaa from table1 where...' ); Open a := FieldByName('aaaa').AsInteger; Close; end; end;
用format('%*.%f',[整数位数,小数位数,值])
就是不知道怎么写呢,请帮助,在下面这个语句怎样改呢? a := FieldByName('aaaa').AsInteger;
a : integer;
begin
with myQuery do
begin
close;
Sql.Clear;
Sql.Add('select sum(a8) as aaaa from table1 where...' );
Open
a := FieldByName('aaaa').AsInteger;
Close;
end;
edn;
querysz.sql.clear;
querysz.SQL.add('select * from xhsz where ');
querysz.SQL.add(' sztype='+'"'+querysztype['sztype']+'"');
querysz.open;
如果SZTYPE是String, 加入""
integer, 不能加""
querysz.sql.clear;
querysz.SQL.add('select * from xhsz where ');
querysz.SQL.add(' sztype='+'"'+querysztype['sztype']+'"');
querysz.open;
var
a : integer;
begin
with myQuery do
begin
close;
Sql.Clear;
Sql.Add('select sum(a8) as aaaa from table1 where...' );
Open
a := FieldByName('aaaa').AsInteger;
Close;
end;
end;
a := FieldByName('aaaa').AsInteger;