Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Index on Ascending/Descending field wise
Message
From
03/04/2000 13:24:57
 
 
To
03/04/2000 11:52:25
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00354206
Message ID:
00354423
Views:
12
Dave,

*repost for better formatting*
>>I see, set the expresion to COMPANY + ACCOUNTCODE + STR(10^16 - DUEAMOUNT) or something close to that. You can do that date the same way.
>
>I see problems with that approach. See what happens with these numbers:
? str(10^16 - 12345678.97)
>? str(10^16 - 12345678.98)
I'd suggest this:<pre>COMPANY + ACCOUNTCODE + STR(0 - dueamount, 15, 2)
Duh. Mine won't work either, since the resulting leading "-" when dueamount starts positive will come *after* a blank space when dueamount starts negative.

So it's back to Craig's suggestion of subtracting dueamount from a larger number, if you have a top limit to valid values. You do, however, need to specify the number of places in the STR command (especially number of decimal places).
David Stevenson, MCSD, 2-time VFP MVP / St. Petersburg, FL USA / david@topstrategies.com
Previous
Reply
Map
View

Click here to load this message in the networking platform