Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Converting a number to only two decimal places
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Converting a number to only two decimal places
Miscellaneous
Thread ID:
00027774
Message ID:
00027774
Views:
81
In my application I have Set Decimals to 3. But I do have some fields where I need to have only 2 decimal places. The datatype on the SQL server is defined as float. How can I tell VFP 5.0 to convert these numbers to only two decimal places, rounding when necessary?

When I tried using Input Mask = 999,999.99, the numbers display with only two decimal places, but they don't round properly.

Jeff
Next
Reply
Map
View

Click here to load this message in the networking platform