Options.QueryRecCount=True with distinct bug
Posted: Tue 18 Dec 2007 14:30
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
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