>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!
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement