You are hereNUMERIC is broken
NUMERIC is broken
Database for test: FirebirdSQL 2.1.2
MSEide+MSEgui : updated trunk
Field in database: NUMERIC(10,2)
Value in database: 0.00
After I set the field value to 1.00 it's stored 100.00 in the database :/
so it stores the value * 100
May be something is broken since your last changes to support 5 decimals. Using 5 decimals is also failing.
Thanks.
Julio
> After I set the field value to 1.00 it's stored 100.00 in the database :/
Please try again with trunk 3085.
> Using 5 decimals is also failing.
tmseibconnection.controller.options dbo_bcdtofloatif activated?
Now it's working as expected. Thank you.
BTW, tmseibconnection.controller.options dbo_bcdtofloatif affects only to numeric values with more than four decimals or to all?
Right now I was casting values to float in the sql sentence like:
select id, cast(numericfield as float) as numericfieldname from sometable...
Julio
> BTW, tmseibconnection.controller.options dbo_bcdtofloatif affects
> only to numeric values with more than four decimals or to all?
Numeric Fields with scale > 4 only, dbo_bcdtofloat*if* ;-)
Martin
I guessed it, but wanted to be sure ;)
Julio