Does anyone have any recommendation on whether it is better to use the currency data type, or stick with a numeric (9,2).
The reasons against using currency is that when you mulitply a currency value with a very small number, such as 0.000493 (like a daily interest rate) you get a rounding error that is large enought to throw off calculations.
It seems to me that useing a numeric with two decimals would make formatting an easy issue, and Fox automatically rounds a numeric when inserting into such a numeric field, so that if you do calculation such as the above and come up with 1.2359 as the amount, it gets rounded to 1.24 automagically.
If anyone has any advice on the subject, I would appreicate it. This is for an accounting type application that needs to be as accurate as possible.
Greg
Greg Gum
Greg@Avasoft.net Avasoft.com / Avasoft.net
800-586-5939
1861 Brown Blvd
Suite 738
Arlington Texas 76006