[OFBiz] Dev - currency-amount field type in Derby db

Posted by Jacopo Cappellato on Oct 07, 2005; 7:28am
URL: http://ofbiz.116.s1.nabble.com/OFBiz-Dev-currency-amount-field-type-in-Derby-db-tp166120.html

Hi all,

I was fighting against some approximation issues with prices, running
OFBiz on top of Derby db, and I've discovered that the db field type for
currency-amount fields for Derby was set to FLOAT and not to
NUMERIC(18,2). This is causing approx problems in OFBiz because the
currency amounts are displayed formatted with two decimals in many
screens and this causes obvious differences when calculating totals etc.

Is this a bug or am I missing something?

Thanks,

Jacopo
 
_______________________________________________
Dev mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/dev