大家好,我查询出所需数据显示在DbGrid中,然后我想在GbDrid下面显示出记录数目及某些字段的合计值,具体应该怎样写啊?QueryAll.Close;
QueryAll.SQL.Clear;
QueryAll.SQL.Add('sum(Total) as 合计,count(*) as 数量from[200210]')
QueryAll.Open;
DbTRecNo.DataField:='?'写得对不对啊?最后一行的DataField怎么写啊?能否直接将DbGrid某一列用Query控件查询出来的数据汇总到DbText里啊?
QueryAll.SQL.Clear;
QueryAll.SQL.Add('sum(Total) as 合计,count(*) as 数量from[200210]')
QueryAll.Open;
DbTRecNo.DataField:='?'写得对不对啊?最后一行的DataField怎么写啊?能否直接将DbGrid某一列用Query控件查询出来的数据汇总到DbText里啊?
我想在DbGrid下面用DbText提示,具体应该怎样写啊?
QueryAll.SQL.Clear;
QueryAll.SQL.Add('select sum(Total) as 合计,count(*) as 数量 from[200210]')
QueryAll.Open;
EditCount.Text:=QueryAll.FieldByName('数量').AsString;
www.51delphi.com
www.playicq.com下载
我又来了,
加入一个DATASOURCE1,DATASET属性设为QUERYALL,
QueryAll.Close;
QueryAll.SQL.Clear;
QueryAll.SQL.Add('sum(Total) as 合计,count(*) as 数量from[200210]')
QueryAll.Open;
dbtext1.datasource:=DATASOURCE1;
dbtext1.fieldname:='合计';
注(数量同理)
QueryAll.SQL.Clear;
QueryAll.SQL.Add('sum(Total) as 合计,count(*) as 数量from[200210]')
QueryAll.Open;dbedit1.text:=QueryAll.fieldbyname('合计').asstring;