22 Oct
2007
22 Oct
'07
3:15 p.m.
On Oct 22, 2007, at 14:12 , Earnie Boyd wrote:
When it comes to accounting systems, floating numbers should be avoided and all data should be stored and processed as integers to avoid rounding issues while processing. Only at the time of representation do we present the fractions by dividing by the most significant fraction (e.g. 100). At the time of input we multiply by the most significant fraction and round as necessary. This also has a benefit of processing faster as integer processing is faster than decimal processing.
Just for the record, the Money CCK field already does this. Wim Leers ~ http://wimleers.com/work