>The manual does say 'Use the Currency data type instead of Numeric for monetary values. If you specify more than four decimal places in a currency expression, Visual FoxPro rounds to four places before evaluating the expression...'. However, this is a serious thing and I for one do not believe that this explanation is in any way sufficient to explain the effect of following the [very clear] recommendation to use currency rather than numeric values at the beginning of the above quote. I can see now that I was foolish, but that does not make me any less pi...ed off. I now have to go back and change approximately 1000 fields in my database to numeric values and who knows what trouble that is going to cause. I have discovered some other little goodies - gomonth will not accept a number that is of type currency.
>
>I have now RTFM and my question now becomes- Of what use is the currency type if you can't do any d..m thing with it.
I agree with your sentiment. I mean one of the common, and critical things with money is the interest you're going to get. Over here you get about 0.1 % on your bank savings, if you're silly enough to use the banks. Now, if you've got $50000 in the bank and get 0.115% interest then you cant go '? MyBalance * 0.00115' can you?, if MyBalance is a currency field. Yech!
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only