D djdsz Unregistered / Unconfirmed GUEST, unregistred user! 2001-03-30 #2 select sum(fieldname) or count(fieldname)就好了啊。你具体要求是什么？
D doud Unregistered / Unconfirmed GUEST, unregistred user! 2001-03-30 #4 Label1.Caption:=Query1.Fields[0].AsStrint;
Y yangkee Unregistered / Unconfirmed GUEST, unregistred user! 2001-03-30 #5 这样做： sql语句写成“select sum(fieldname) as total from ..."或者select count(fieldname) as number from ..." 要显示出来分别是fieldbyname('total').asInteger或fieldbyname('number').asInteger
这样做： sql语句写成“select sum(fieldname) as total from ..."或者select count(fieldname) as number from ..." 要显示出来分别是fieldbyname('total').asInteger或fieldbyname('number').asInteger
无 无题 Unregistered / Unconfirmed GUEST, unregistred user! 2001-04-02 #8 inttostr(dbgrid1.DataSource.DataSet.RecordCount)
D delphi_jzy Unregistered / Unconfirmed GUEST, unregistred user! 2001-04-03 #9 1.select sum(fieldname) as total from table_name; 2.var sum:=integer; sum:=fieldbyname('total').asInteger; 3.建议学习sql语言;
1.select sum(fieldname) as total from table_name; 2.var sum:=integer; sum:=fieldbyname('total').asInteger; 3.建议学习sql语言;
