Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Multiple index ASC / DESC
Message
From
15/05/2000 16:48:54
 
 
To
15/05/2000 15:26:03
Arnaudon Olivier
Teamlog Enterprises Solutions
Mulhouse, France
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00369394
Message ID:
00369781
Views:
26
>Thanks for the answer but where can i find the syntaxe
>
>The first fields is numerical (order DESC) and the both second are alphanumerical (order ASC)
>
>
>Thanks !!!

INDEX ON STR(999999999 - Field1) + Field2 + Field3 TAG MyTag

You'll need to adjust the STR function to handle decimals.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform