QueryRecCount and Distinct

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Sid
Posts: 4
Joined: Mon 30 Jan 2012 21:54

QueryRecCount and Distinct

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
Posts: 4
Joined: Mon 30 Jan 2012 21:54

QueryRecCount and Union

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
Posts: 4
Joined: Mon 30 Jan 2012 21:54

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.

Post Reply