Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
STR() not work
Message
 
To
30/09/2004 09:43:16
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00947504
Message ID:
00947507
Views:
15
I try to replace a numeric field with str() but not work

STR() will transform a numeric value to a character string. You most likely will trigger an error if you are trying to replace a numeric field with a character string.

If the values are both numeric try:
REPLACE accountchr WITH int(account_am)
>Hello,
>
>I try to replace a numeric field with str() but not work,
>
>account_am = 1948.00 to have accountchr = 1948 without .00 after and does not
>any space after too.
>
>means only 1948 in accountchr nothing more.
>
>with
>
>REPLACE accountchr WITH STR(account_am,16,0)
>
>Any help would be appreciated
>
>TIA
Previous
Reply
Map
View

Click here to load this message in the networking platform