On Fri, 22 Jul 2011, WR Consulting wrote:
Rich, one of the things that I found quite surprising about SL when I first started "peeking under the hood" was its use of a floating-point type for monetary amounts.
ARRRGGH-H-H-H!!! I learned not to do this in 1984 with dBASE II. Even with today's dbms (such as postgres) you cannot select rows based on a floating point number. This is a terribly eggregious design/coding error. If this is still the case, changing all those floats to (for example) numeric(8,2) will cover all of us with bank balances < 99,999,999.99 in our local currencies. Wow! While I'm not surprised based on what other perl mongers have written about the original DS code, I'm seriously disappointed. Rich _______________________________________________ SQL-Ledger mailing list [email protected] http://lists.ledger123.com/mailman/listinfo/sql-ledger
