>>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