Divide by 10 Error

itsds · Post by **itsds** » Thu 17 May 2007 22:08

I have a problem with the new (self compiled) Version of dbexpmda.dll.

The values of a field of type decimal(10,2) are divided by 10 so 100 gets 10 and 2 is 0,2
Changing the Type to float returns the correct values

How can I debug this problem to solve it ?

here is my makefile - the other files are untouched !
it's BDS2006 with the latest SP

set Ide="c:\Program Files (x86)\Borland\BDS\4.0\Bin\dcc32.exe"
%Ide% -LE. -K400000 -B -V- -VR- -DDBX30 -$D- -$Y- -$L- -$O+ -E dbexpmda.dpr

Antaeus · Post by **Antaeus** » Fri 18 May 2007 10:25

Most likely this is a problem with the NormalizeBCD function of BDS. We will investigate this issue in the nearest time. As soon as we have a result, we will let you know.

Jackson · Post by **Jackson** » Thu 24 May 2007 08:22

It seems that you use dbexpmda.dll as a library name in TSQLConnection.
It is strongly recommended to use the dbexpmda30.dll driver with Delphi 2006, Turbo Delphi, Turbo Delphi for .NET and Turbo C++.
Please see ReadMeSrc.txt for information about how to compile and install dbExpress driver for Delphi 2006.

itsds · Post by **itsds** » Tue 29 May 2007 10:03

Hi Jackson, i use dbexpmda30.dll which is "renamed" to dbexpmda.dll

Jackson · Post by **Jackson** » Tue 29 May 2007 15:01

We could reproduce the problem only when using dbexpmda.dll but not with dbexpmda30.dll or its renamed version. Please make sure that you have properly compiled and installed DbxMda for Delphi 2006.
Detailed description of how to compile and install dbExpress driver for MySQL for Delphi 2006, Turbo Delphi, Turbo C++ you can find in the DbxMda_InstDir\ReadMeSrc.txt file. DbxMda_InstDir is the DbxMda installation directory on your computer.