Page 1 of 1
QueryRecCount and Distinct
Posted: Mon 30 Jan 2012 22:05
by Sid
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?
Posted: Tue 31 Jan 2012 08:56
by AndreyZ
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.
QueryRecCount and Union
Posted: Wed 01 Feb 2012 17:14
by Sid
QueryRecCount also throws error when there is 'UNION' in the sql statement.
Posted: Thu 02 Feb 2012 09:17
by AndreyZ
Thank you for the information. We will fix both problems in the next SDAC build.
Posted: Wed 08 Feb 2012 22:12
by Sid
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?
Posted: Thu 09 Feb 2012 08:20
by AndreyZ
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.