With Query1 do begin Close; SQL.Clear; SQL.Add('select StrField, sum(NumField) from Table where DateField between :StartDate and :EndDate Group by StrField'); ParamByName('StartDate').asDateTime:=Date-30; ParamByName('EndDate').asDateTime:=Date; Open; ');
最好用变量,不同的数据库不太一样,我上次用access做后台,这样写就不行。 with query1 do close; clear; select sum(JinE) from orders where RiQi<:aa and riqi>:aa ......
Close;
SQL.Clear;
SQL.Add('select StrField, sum(NumField) from Table where DateField between :StartDate and :EndDate Group by StrField');
ParamByName('StartDate').asDateTime:=Date-30;
ParamByName('EndDate').asDateTime:=Date;
Open;
');
with query1 do
close;
clear;
select sum(JinE) from orders where RiQi<:aa and riqi>:aa
......