Thanks for tying it back into programming :)


>>>Your money will soon be worthless.
>>>
>>>http://www.foxnews.com/story/0,2933,432282,00.html
>>
>>But there will be lot of it and it will be easy to borrow ! ;-)
>
>My advice: have all your fields maxed out at n(20,2) and be ready to turn them into n(20,0). Keep in mind that IEEE number format holds only 15.5 significant digits, so if your totals need to cancel out on each denomination, make sure that all the monetary transactions in your tables have strictly controlled dates, i.e. you don't want this week's transaction expressed in last week's money, or you'll never get out of fixing things.
>
>Also, have picture strings somewhere in an .ini file (so you can just add nines in a minute remotely), like this
>
>pcPrice="999,999.99"
>pcAmount="999,999,999.99"
>
>and keep them as properties of a global object. In your textbox subclasses, set the inputmask appropriately, in .init() have a
>
>this.inputmask=goApp.oConfig("pcPrice")
>
>or something of the kind. Make it dependent on some cutoff date, if you want, so amounts expressed in old money can have more zeros, and then anything in new money will have fewer (which is why I say, to be strict with dates). Design your transactions to be able to annihilate everything at the current price at 23:59:59 one day, and have it returned with two, three... or even six zeros less at 00:00:00 the next day. Think of adding extra space to your reports, and it may be worth your time to do them in HTML or Excel - the first one is flexible, the other one allows you to serve raw data and leave the formatting to the user :).
>
>Learn the difference between proportional interest calculation (where the rate for n days is rate*days/365) and the conform method (where the rate is ((1+rate/100)**(days/365)-1)*100... or just drop the 100 and work with real coefficients). At rates of up to 20% they don't differ much (one is a straight line, the other is exponential), but at 30% the difference between interest added to the capital immediately and the one added on 31st of December may mean a lawsuit.
>
>Have fun!