select count(*) as NUM from TableName where ....FieldByName('NUM').AsInteger
对。 如果是Select Count(*) From Tablename Where 访问结果,只能用列序号访问值 Fields[0].AsInteger;如果要以名称的方式访问,就必须取个别名 如果是Select Count(*) As 别名 From Tablename Where FieldByName('别名').AsInteger
也可 GROUP By 一起 求某一个类的总和
select count(*) as NUM from TableName where .... FieldByName('NUM').AsInteger
1楼的回答正确 select count(*) as cc from table_1 获取的话就像你获取select filed_1 from table_1一样,Query.FiledValue['cc']就可以得到
如果是Select Count(*) From Tablename Where
访问结果,只能用列序号访问值 Fields[0].AsInteger;如果要以名称的方式访问,就必须取个别名
如果是Select Count(*) As 别名 From Tablename Where
FieldByName('别名').AsInteger
select count(*) as cc from table_1
获取的话就像你获取select filed_1 from table_1一样,Query.FiledValue['cc']就可以得到