Decimals: one digit too few

Discussion of open issues, suggestions and bugs regarding usage of dbExpress drivers for MySQL in Delphi and C++Builder
Post Reply
Posts: 3
Joined: Thu 07 Jun 2007 15:37

Decimals: one digit too few

Post by mpcsmits » Tue 12 Jun 2007 13:26

I have my SQL field defined as DECIMAL(6,1) which means I can insert a max value of 99999.9 into the field. This works perfectly when using the MySQL query browser for example.

However when editing the field in Delphi (D2006) the max value I can enter is only 9999.9.

I am using the MySQL sdirect driver in combination with TSimpleDataSet . Is this a driver issue or do I have to look elsewhere ?

Posts: 2098
Joined: Tue 14 Feb 2006 10:14

Post by Antaeus » Wed 13 Jun 2007 08:48

I could not reproduced the problem with BDS 2006. I can insert and browse all acceptable values for DECIMAL(6,1), including 99999.9.
I tested this issue with the last version of DbxMda (3.20.5), MySQL 5.0.20, BDS 2006 Win32 application.

Please send me a complete small sample at evgeniyD*crlab*com to demonstrate it, including script to create and fill table.

Also supply me the following information:
- exact version of DbxMda.
- exact version of MySQL server.

Posts: 1
Joined: Mon 21 Jan 2008 20:54

I found the same problem,

Post by omarperezh » Mon 21 Jan 2008 23:24

If we check data with a standard driver of Delphi 2007 the value returned is 99.99
but if we use Core Labe connector the value is 9.9

I attached a program to test this bug, This program check bug using Core Lab Connector
Delphi 2007
MySQL 4.22

I attached a program to reproduce error, download it from: ...

Devart Team
Posts: 2885
Joined: Mon 05 Mar 2007 16:32

Post by Dimon » Tue 22 Jan 2008 14:41

Thank you for information. We have reproduced this problem and fixed it. This fix will be included in the next DbxMda build.

Post Reply