From: Mike S. <ms...@md...> - 2007-02-20 01:24:52
|
In FrontBase, the "amount" prototype is a BigDecimal, DECIMAL(38,2) -- suitable for storing currency. In all the other prototypes, that's not the case (it's just a double). I actually changed FrontBase's definition back in Apr 06 because the original definition of amount was not a valid datatype. However, I apparently also made it currency-suitable with a valueType B. Now, though, I'm converting something that depends on this prototype to Postgresql, and obviously this doesn't fly as I get ClassCastExceptions all over the place with Doubles coming back. There does not appear to be a currency-capable datatype in ERPrototypes (none are valueType = B). Is this an oversight? Does anyone use "amount"? If not, should amount change to BigDecimal, or should there be a "currencyAmount" added (or something like that) that is a fixed precision BigDecimal value? ms |