查询返回总数

Question

          with adoquery1 do
          begin
            close;
            sql.Clear;
            sql.Add('Select GameName from [Game] where GameName="'+GameName1+'"');
            execsql;
          end;我想返回符合这条SQL语句的值的总数

Answer 1

          with adoquery1 do 
          begin 
            close; 
            sql.Clear; 
            sql.Add('Select GameName from [Game] where GameName="'+GameName1+'"'); 
            Open; 
            last;
            cnt:=RecordCount;
          end; 

Answer 2

with adoquery1 do 
begin 
  close; 
  sql.Clear; 
  sql.Add('Select GameName from [Game] where GameName="'+GameName1+'"'); 
  Open; 
  cnt:=RecordCount; 
end;Open意思是打开数据集，对应select操作。ExecSQL只是执行这条sql语句，对应update, delete操作。

Answer 3

  下面的代码就可以解决你的问题 
        with adoquery1 do 
          begin 
            close; 
            sql.Clear; 
            sql.Add('Select GameName from [Game] where GameName="'+GameName1+'"'); 
            Open; 
            last; 
            cnt:=RecordCount; 
          end; 
    Open; execsql; 都可用
    但是在Insert Update,Delete的时候就只能用 execsql 

Answer 4

楼主是要记录条数的总数还是所有满足GameName的和呢？
with adoquery1 do 
begin 
  close; 
  sql.Clear; 
  sql.Add('Select sum(GameName) from [Game] where GameName="'+GameName1+'"'); //GameName列的总和
  //sql.add('select count(GameName) from [Game] where GameName='''+GameName1+'''');记录条数
  Open; 
end;