Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Index on multiple columns (fields)
Message
From
23/07/2003 10:13:04
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
 
To
23/07/2003 00:44:24
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00812633
Message ID:
00812768
Views:
20
>Hi Hilmar,
>
>Based on your ealier example I managed to find a way to sort Numeric fields, however still not sure about character fields, pls let me know if you know a way to so.

You could also create a UDF, which takes the entire character expression and inverts it (chr(255) becomes chr(0), chr(254) becomes chr(1), etc.), but this can make the indexing much slower.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Previous
Reply
Map
View

Click here to load this message in the networking platform