Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Trim for numbers
Message
 
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00263216
Message ID:
00263223
Views:
34
>Is there a function like trim(expression)
>to be used with numeric fields ?

Are you trying to convert a numeric to a character string? If so, see the STR() function -- lcValue = str(lnvalue, 5, 2). That example returns a character string of width 5 with 2 decimal places.

If you are looking to leave it numeric, there is always SET DECIMALS TO X where X is the number of decimal places. If you need to mask the input for a textbox control, use the InputMask property of the textbox. e.g., 99.99. This is equivalent to the PICTURE clause in FP 2.x.
Mark McCasland
Midlothian, TX USA
Previous
Reply
Map
View

Click here to load this message in the networking platform