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
QueryRecCount
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.
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.