Why don't you use the Currncy field type, then most like NO changes are necessary?
>In moving everything from VFP 6 to VFP 8 I am looking at the Double Field Type. I have a large number of fields in many tables set to N(12,2) for holding total dollar amounts in things like invoices, payments etc. and a number of others for holding Quanties such as N(8,3). I see that I can enter the double data type and then enter a decimal number when modifying tables. I assume the decimal number is only what is displayed.
>
>I am looking at changing all my N(xx,x) types to Double and am looking for input as to weither this is a good or bad idea and any hints as to what to look for.
>TIA