Export (0) Print
Expand All

Currency Data Type

To store monetary values or precise financial calculations, use the Currency data type instead of Numeric.

NoteTip

You can convert values from Numeric to Currency and the reverse using the NTOM( ) and MTON( ) functions. For more information, see Numeric Data Type, NTOM( ) Function, and MTON( ) Function.

To assign the Currency data type, use the dollar sign:

money = $50.33
moremoney = $675.43886

If you specify more than four decimal places in a currency expression, Visual FoxPro rounds to the expression to four places before evaluating the expression. In the example, the variable moremoney is internally rounded to 675.4389.

Currency fields respect system settings, such as SET CURRENCY, when displayed in Browse windows, fields, or when listed to the screen.

For more specifications about the Currency data type, see Visual FoxPro Data and Field Types.

Community Additions

ADD
Show:
© 2014 Microsoft