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 ?
Decimals: one digit too few
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 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,
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
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