On Aug 15, 2008, at 12:00, David Avendasora wrote:
How currency-centric of you. If you are selling widgets that are really small, or you have a very strong currency, you may want to keep track of a cost that is < .01 for calculations, even if the value presented to the customer ends up getting rounded to 2 decimal points. With some currencies you don't even need decimal points. Colombian Peso, USD, etc.
I guess that's a good point, increasing the scale when things are being calculated, reducing it when it is being displayed.
However, I am not sure I should actually store the extra precision. In our situation, we would store the value in some currency *as it is on the invoice*, and then at runtime possibly calculate it into other currencies, but would not store the result. So, unless there are currencies that per se require more then 2 precision digits, we gain nothing by extra precision on the db layer. See my point?
F _______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([email protected]) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [EMAIL PROTECTED]
