adoquery1.SQL.Add('select sum(house_pri) fsum from gwlk')将dbedit的field设为fsum即可。
adoquery1.SQL.Add('select sum(house_pri) as house_pri_sum from gwlk'); 设置DBEdit的DataField属性为house_pri_sum
adoquery1.SQL.Add('select sum(house_pri) as fsum from gwlk')将dbedit的field设为fsum即可。一定要加as哦
楼上这位说得好像不行,datafield里面只有这个表的字段,怎么能设置fsum呢?
datafield里面时可以手工写的,写成fsum就可以了
我按照上面做了,可是没有反应啊。不知是哪里出错了,忘高手指点一下 procedure TForm1.sbtnslClick(Sender: TObject); var sel:boolean; spri:string; begin sel:=(not rbroom.Checked) and (not rbgoods.Checked) and (not rbdinner.Checked) and (not rbgame.Checked); if sel then showmessage('请选择收入的方式') else if rbroom.Checked then begin dataModule1.ADOQ_sl.Close; dataModule1.ADOQ_sl.SQL.Clear; dataModule1.ADOQ_sl.SQL.Add('select sum(house_pri) as spri from gwlk'); dataModule1.ADOQ_sl.Open; dbedit1.DataField:=spri; end; end; end.
adoquery1.SQL.Add('select sum(house_pri) as fsum from gwlk')将dbedit的field设为fsum即可。一定要加as哦 ***************************************** 一定要吗??SQL SERVER就不要
该为 procedure TForm1.sbtnslClick(Sender: TObject); var sel:boolean; begin sel:=(not rbroom.Checked) and (not rbgoods.Checked) and (not rbdinner.Checked) and (not rbgame.Checked); if sel then showmessage('请选择收入的方式') else if rbroom.Checked then begin dataModule1.ADOQ_sl.Close; dataModule1.ADOQ_sl.SQL.Clear; dataModule1.ADOQ_sl.SQL.Add('select sum(house_pri) as spri from gwlk'); dbedit1.DataField:='spri'; dataModule1.ADOQ_sl.Open; end; end; end.
设置DBEdit的DataField属性为house_pri_sum
procedure TForm1.sbtnslClick(Sender: TObject);
var
sel:boolean;
spri:string;
begin
sel:=(not rbroom.Checked) and (not rbgoods.Checked) and (not rbdinner.Checked) and (not rbgame.Checked);
if sel then
showmessage('请选择收入的方式')
else if rbroom.Checked then
begin
dataModule1.ADOQ_sl.Close;
dataModule1.ADOQ_sl.SQL.Clear;
dataModule1.ADOQ_sl.SQL.Add('select sum(house_pri) as spri from gwlk');
dataModule1.ADOQ_sl.Open;
dbedit1.DataField:=spri;
end;
end;
end.
你不要把spri定义成变量,然后写上
dbedit1.DataField:='spri';
再看看
adoquery1.SQL.Add('select sum(house_pri) as fsum from gwlk')将dbedit的field设为fsum即可。一定要加as哦
*****************************************
一定要吗??SQL SERVER就不要
procedure TForm1.sbtnslClick(Sender: TObject);
var
sel:boolean;
begin
sel:=(not rbroom.Checked) and (not rbgoods.Checked) and (not rbdinner.Checked) and (not rbgame.Checked);
if sel then
showmessage('请选择收入的方式')
else if rbroom.Checked then
begin
dataModule1.ADOQ_sl.Close;
dataModule1.ADOQ_sl.SQL.Clear;
dataModule1.ADOQ_sl.SQL.Add('select sum(house_pri) as spri from gwlk');
dbedit1.DataField:='spri';
dataModule1.ADOQ_sl.Open;
end;
end;
end.