Problems with distinct

Guest · Post by **Guest** » Thu 26 May 2005 08:44

I'm using Delphi 7.1 and MySQL Direct driver 2.5.3 with MySql 4.0.3 beta. The TSQLquery "select distinct glava from smsdnevnik" returns Server Error: Range check error. If i change the query to "select glava from smsdnevnik" it works fine. The same query works OK with borland driver.

Ikar · Post by **Ikar** » Thu 26 May 2005 11:28

Please update to stable MySQL version. If problem persists then send us complete small sample to demonstrate it and include script to create server objects.

Ikar · Post by **Ikar** » Fri 27 May 2005 12:22

Thank you for information.
We reproduced your problem and fixed it. This fix will be included in the next DbxMda build. It will be available in about two weeks.