Page 1 of 1

SELECT returns wrong value

Posted: Thu 06 Jul 2006 14:31
by david66
hello ,
i don't understand why this : select toto from table

if toto value is 0.00955882352941177 the query return this value : 9558823529.4

if toto value is 0.0110294117647059 the query return this value : 0.011029411765


i don't understand why ?


i using 4.30.1.15 mydac component and mysql 4.1 and delphi 7

Posted: Thu 06 Jul 2006 20:40
by swierzbicki
are you using float fields ? , have you tried this with double fields type instead ?

Posted: Fri 07 Jul 2006 06:17
by david66
I m using Double Field

Posted: Fri 07 Jul 2006 08:27
by Zagawa
I have the same kind of problem with Delphi 5 and the lastest version of Mydac Component.

I tested it with MyODBC / BDE standard component and the result is correct.

With MyDac, for the same value in a float and in a Double field, result for float field is correct and it is not correct for double field.

Posted: Fri 07 Jul 2006 14:22
by Antaeus
Thank you for information. We have reproduced this problem and fixed it. This fix will be included in the next MyDAC build. The next build of MyDAC will be available in the nearest few days.