Page 1 of 1

Error with decimal fields

Posted: Thu 30 Jun 2005 16:10
by Pippo
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

Posted: Thu 30 Jun 2005 16:24
by Ikar
Thank you for information.
It's known problem and we've already fixed it.
Please download the last DbxMda version.

wow

Posted: Thu 30 Jun 2005 16:29
by Guest
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

Posted: Fri 01 Jul 2005 06:31
by Ikar
Use TRANSISOLATION_KEY (eConnTxnIsoLevel) parameter.
Please see Borland dbExpress documentation for details