Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Question on STR()
Message
 
 
To
09/09/2003 10:24:10
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00827477
Message ID:
00827480
Views:
17
This message has been marked as the solution to the initial question of the thread.
Hi Denis,

The decimal point character is controlled by SET SYSFORMATS and SET POINT commands which are scoped to the current data session.

>VFP6
>
>I have a decimal field: 1234567891,12
>
>I have an index on that decimal field: str( DecimalField,13,2)
>
>To search for a value based on that index I want to do a seek. To be able to do that seek I do a STR() on the numeric data.
>
>The problem is that str returns a result like this: "1234567891.12"
>
>Is there a way to tell STR() that the result should be in the form "1234567881,12"
>instead of <1234567891.12>?
>
>I know that I could do a STRTRAN() on what comes out of STR() but I'm wondering if there would be a better option.
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform