Page 1 of 1

...

Posted: Thu 30 Jun 2005 23:18
by Guest
Well, about numeric fields..
I'm making some "field type compatibility tests" across dbxoda and dbxmda.
I have a simple app (d2005) with two sqlconnections, one to mysql (5.0.7) and one to Oracle (8.1.7); and one sqlquery.
- set connection in sqlquery to mysql, create persistent fields, numeric are mapped as float. (even is readme tells DECIMAL = BCD but this is another story... :wink: )
- close query, switch connection to oracle, open, no errors.
- close query and open again, BUM! Expected BCD actual Float....

Posted: Fri 01 Jul 2005 10:58
by Paul
You must configure DbxOda how to work with NUMBER() fields. Please use
TCRSQLConnection and EnableBCD parameter for switching between BCD and Float
fields (default is BCD, please see ReadMe.html for more details). Please
write to dbExpress driver for MySQL forum about errors with DbxMda.