Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Index on Ascending/Descending field wise
Message
From
03/04/2000 18:02:58
 
 
To
03/04/2000 17:00:23
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00354206
Message ID:
00354666
Views:
23
Mike,

>How was that different from my suggestion to substract from a larger number, the one you said was flawed? But he had a 15 length numeric field, that's why I chose 10^16. Your right that I do need to add str(,23) though.

Did you test the two lines I used to illustrate the problem?
? str(10^16 - 12345678.97) 
? str(10^16 - 12345678.98)
Or how about with smaller, more reasonable numbers (including negative amountdue), and with your suggestion of str(,23):
? str(10^16 - 2.48,23)  = "       9999999999999998"
? str(10^16 - 2.98,23)  = "       9999999999999998"
? str(10^16 - -2.48,23) = "      10000000000000000" 
? str(10^16 - -5.48,23) = "      10000000000000000"
Adding 2 decimal places to the STR command also fails:
? str(10^16 - 2.48,26,2)  = "       9999999999999998.00"
? str(10^16 - 2.98,26,2)  = "       9999999999999998.00"
? str(10^16 - -2.48,26,2) = "      10000000000000000.00" 
? str(10^16 - -5.48,26,2) = "      10000000000000000.00"
David Stevenson, MCSD, 2-time VFP MVP / St. Petersburg, FL USA / david@topstrategies.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform