Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ASCENDING and DESCENDING indexes?
Message
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00192865
Message ID:
00193016
Views:
45
>>Hello Edward,
>>
>>I want to index on on group of logical fields (DESCENDING) and a character field (ASCENDING)
>
>You may do something like:
>INDEX ON IIF(logfield1=.T.,"B","A")+IIF(logfield2=.T.,"A","B").... +charfield TAG Mytag

Are you using this index to order the records in a report, or the rows in a grid, or for a reason such as that? I assume you are, since this index will be useless for Rushmore.

If that's true, may I suggest that you will get better performance with a SQL SELECT which has an appropriate ORDER BY clause? Individual ORDER BY items in a SQL SELECT can each be specified with ASC or DESC keyword.

HTH,
Rich.
Rich Addison, Micro Vane, Inc., Kalamazoo, MI
Relax, don't worry, have a homebrew.
- Charlie Papazian, The New Complete Joy of Home Brewing
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform