Page 1 of 1
Decimals: one digit too few
Posted: Tue 12 Jun 2007 13:26
by mpcsmits
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 ?
Posted: Wed 13 Jun 2007 08:48
by Antaeus
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.
I found the same problem,
Posted: Mon 21 Jan 2008 23:24
by omarperezh
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:
http://e-globalprojects.diinoweb.com/fi ... ection.zip
Posted: Tue 22 Jan 2008 14:41
by Dimon
Thank you for information. We have reproduced this problem and fixed it. This fix will be included in the next DbxMda build.