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

Count record.

Post by Per » Mon 22 Nov 2004 09:18

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


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]

Post Reply