Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Question on STR()
Message
From
09/09/2003 10:36:44
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00827477
Message ID:
00827483
Views:
18
>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.

Thank you Sergey.
*******************************************************
Save a tree, eat a beaver.
Denis Chassé
Previous
Reply
Map
View

Click here to load this message in the networking platform