QueryRecCount and Distinct

Sid · Post by **Sid** » Mon 30 Jan 2012 22:05

I am using Delphi 2007 and SDAC Professional Version 6.0.2. TMSQuery with FetchAll=False and QueryRecCount=True is giving incorrect recordcount when there is 'Distinct' in the sql statement for the query. It doesn't seem to take 'Distinct' in account for recordcount. What is the solution?

AndreyZ · Post by **AndreyZ** » Tue 31 Jan 2012 08:56

Hello,

Thank you for the information. We reproduced the problem and the investigation is in progress. We will notify you when we have any results.

Sid · Post by **Sid** » Wed 01 Feb 2012 17:14

QueryRecCount also throws error when there is 'UNION' in the sql statement.

AndreyZ · Post by **AndreyZ** » Thu 02 Feb 2012 09:17

Thank you for the information. We will fix both problems in the next SDAC build.

Sid · Post by **Sid** » Wed 08 Feb 2012 22:12

AndreyZ wrote:Thank you for the information. We will fix both problems in the next SDAC build.

We have recently upgraded to this 6.0.2 version. What is the tentative time frame for the next build to be available?

AndreyZ · Post by **AndreyZ** » Thu 09 Feb 2012 08:20

We plan to release new builds of all DAC components as soon as RAD Studio XE2 Update 4 is released. This way, we will be able to provide all DAC components compatible with the new update.

Devart Forums

QueryRecCount and Distinct

QueryRecCount and Distinct

QueryRecCount and Union