AdoQuery.SQL.Add('select count(*) from Table);

-
AdoQuery.SQL.Add('select count(*) from Table);
Where do I find the result (without using DBEdit connected to the DataSource & datafield=Expr1000)?

Comments

  1. Dan Statham (GreatDayDan)January 26, 2014 at 10:47 AM

    var
      iCount: integer;
    begin
      AdoQuery.SQL.Add('select count(*) from Table);
      try
        AdoQuery.Open;
        iCount := AdoQuery.Fields[0].AsInteger;
        AdoQuery.Close;
      except
        iCount := -1;
      end;
    end;

    ReplyDelete
  2. Heinz ToskanoJanuary 26, 2014 at 2:53 PM

    or the easy way:
    ...
    AdoQuery.SQL.Add('select * from table');
    AdoQuery.Open;
    icount:=AdoQuery.RecordCount;
    AdoQuery.Close;
    ...

    ReplyDelete
  3. Stefan GlienkeJanuary 26, 2014 at 11:33 PM

    Heinz Toskano Yeah and the easy way then transfers the bazillion records over the net into your ADOTable...

    ReplyDelete
  4. Olivier SCHWABJanuary 27, 2014 at 12:18 AM

    Stefan Glienke using Recordcount is a bit lame ; I propose 

    While not AdoQuery.Eof do inc(icount);

    ReplyDelete
  5. Stefan GlienkeJanuary 27, 2014 at 12:20 AM

    Olivier SCHWAB LOL /facepalm

    ReplyDelete
  6. Heinz ToskanoJanuary 27, 2014 at 12:51 AM

    Stefan Glienke You're right, maybe not the best way, but it's easier and works... and will waste a lot of resources and time.
    Seriously Olivier SCHWAB? ;-)

    ReplyDelete
  7. Olivier SCHWABJanuary 27, 2014 at 12:53 AM

    Sorry Heinz Toskano , bad monday at work , so my tongue is a little bit sarcastic ;)

    ReplyDelete
  8. Heinz ToskanoJanuary 27, 2014 at 12:59 AM

    Olivier SCHWAB np man, we all have a bad day, sometimes, specially mondays, mine is just about to begin ;-)

    ReplyDelete
  9. Warren PostmaJanuary 28, 2014 at 4:22 AM

    Abderak open the dataset and get Fields[0].value

    ReplyDelete

Post a Comment