Devart Forums

Hi,

I upgraded to MySQL 5 and have wrong result in my query. Details bellow :

Delphi 5 OR Delphi 6, MyDAC 5.55.0.26, MySQL 5.0.18

Table test
Kode varchar(11)
Qty decimal(9,2)
Price decimal(15,4)
Disc decimal(6,4)
Tax decimal(6,4)
Kurs decimal(10,4)

My Query like this :
Select Kode,Qty,Price,Disc,Tax,Kurs,Qty*Price*Kurs*(1-(Disc/100))*(1+(Tax/100)) Total from test

IF I direct run this query with SQLYog, i have the correct result. But if i use mydac in my apps the result is wrong. Any idea?

Thanks.
hs

Thank you for information. We have reproduced this problem. The investigation of the problem is in progress. Unfortunately now we cannot give you any information. As soon as we solve the problem we'll let you know.
As temporary solution you can set MyQuery.Options.FieldsAsString to True.

this bug also applies to the 4.x version of MyDAC?

Yes. We have reproduced this bug using the latest build of MyDAC.

We have fixed this problem. This fix will be included in the next MyDAC build.