Count record.

Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Per

Count record.

Post by Per » Mon 22 Nov 2004 09:18

Hi.
How do i use mydac components to count the records in a innodb table?

//Per
Top
Ikar
Posts: 1693
Joined: Thu 28 Oct 2004 13:56

Re: Count record.

Post by Ikar » Mon 22 Nov 2004 13:11

You can execute SELECT and get data from DataSet.RecordCount or execute SELECT COUNT(*) FROM TableName and receive a number of records from Query.Fields[0]
Top
Post Reply

Return to “MySQL Data Access Components”