Page 1 of 1

Options.QueryRecCount=True with distinct bug

Posted: Tue 18 Dec 2007 14:30
by GuzunNicolae
Hello

I guess I have spotted a bug in MyDAC.
I have a query: 'SELECT distinct id FROM table' and for that query Options.QueryRecCount=True

So when I open he query it does not include COUNT(distinct id) rather it makes it 'SELECT COUNT(*) FROM table' which is wrong

Posted: Fri 21 Dec 2007 14:06
by Dimon
Thank you for information. We have reproduced this problem and fixed it. This fix will be included in the next MyDAC build.