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

>>2) Company C(05) Ascending
>> AccountCode C(05) Ascending
>> DueAmount N(15,2) Descending
>
>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)<pre>I'd suggest this:<pre>COMPANY + ACCOUNTCODE + STR(0 - dueamount, 15, 2)
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