Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Determining decimal places
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00358148
Message ID:
00358160
Views:
13
>Use transform() instead (without a format code). It won't truncate or round the number.
>
>>Is there a way to determine the # of decimal places in a number. I need to export data from tables. Once I know that the field is numeric I need to know how many decimal places there are for the str() command.
>>

Peter,
I was thinking along those same lines but transform() does truncate trailing zeros when a format string is not specified. So if your field is N(6,4) and you have a value in it of 8.2500, transform will return 8.25.
Larry Miller
MCSD
LWMiller3@verizon.net

Accumulate learning by study, understand what you learn by questioning. -- Mingjiao
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform