Change the currency fields to DOUBLE temporarily, then change the
currency settings, then change the fields back to currency. I had to do
this in a db where currency was set to 5 decimals once upon a time.
Albert
Dan Goldberg wrote:
I need to change the subunit digits from the normal two digits to four
digits.
The problem I have is when I change all my numbers shift over.
Example
10.99 is now .1099
How can I keep the decimal in the same place without having to multiple the
numbers in all the tables?
Dan Goldberg