Error with decimal fields

Pippo · Post by **Pippo** » Thu 30 Jun 2005 16:10

Hi all, I'm evaluating your driver with beta version of mysql (5.0.7)
Driver seems unable to read from fields defined as DECIMAL. I've tried various size and precision (range from 15,3 to 9,0) and to define my table as InnoDb or MyIsam, but nothing to do...
With FLOAT or INTEGER no problems.

The error I obtain is: SQL Server Error: Unknown MySql datatype (246)
(D:\Projects\Delphi\Mydac\Source\MyClasses.pas, line 878)

The version I have here is 2.50.4.0

Thank you

Ikar · Post by **Ikar** » Thu 30 Jun 2005 16:24

Thank you for information.
It's known problem and we've already fixed it.
Please download the last DbxMda version.

Guest · Post by **Guest** » Thu 30 Jun 2005 16:29

wow, what a quick reply!!!
by the way... I've seen that other drivers let assign transisolation level from sqlconnection.. how is this achieved with dbxmda?
thanks

Ikar · Post by **Ikar** » Fri 01 Jul 2005 06:31

Use TRANSISOLATION_KEY (eConnTxnIsoLevel) parameter.
Please see Borland dbExpress documentation for details