Page 1 of 1

Problems with distinct

Posted: Thu 26 May 2005 08:44
by Guest
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.

Posted: Thu 26 May 2005 11:28
by Ikar
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.

Posted: Fri 27 May 2005 12:22
by Ikar
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.