QueryRecCount

Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
RH
Posts: 31
Joined: Sat 16 Sep 2006 06:32

QueryRecCount

Post by RH » Tue 19 Sep 2006 23:58

Hi

I have a TQuery that has Options.QueryRecCount=true, but I can see from the MySQL log file, that there is no additional query being executed to get number of records (as the corelab help file says). But the RecordCount reflects the number of actual records correctly....

Besides if I set the Options.QueryRecCount to false, then the RecordCount still reflects the number of actual records correctly....

What is the use of Options.QueryRecCount then? And should it be true or false ? And when exactly will there be an extra query sent to the MySQL server ?

kind regards

Antaeus
Posts: 2098
Joined: Tue 14 Feb 2006 10:14

Post by Antaeus » Wed 20 Sep 2006 11:04

This is just inaccuracy in documentation. We will revise our documentation before release of the next MyDAC version.
QueryRecCount option have a sense only for FetchAll=False mode. If FetchAll=True we just count records received to the client. No additional round-trip to the server is necessary. In FetchAll=False mode we have to execute SELECT statement to fill RecordCount property correctly.

RH
Posts: 31
Joined: Sat 16 Sep 2006 06:32

Post by RH » Wed 20 Sep 2006 15:58

Thank you very much. And I am looking forward for a new version of the components :D

Post Reply