Descending index on a view 2

[paul060769]

I have a grid that displays a local view.

I want to be able to index the records of the view based upon a field (lastname) in ascending OR descending order.

I can't use the ASCENDING or DESCENDING clause in the INDEX ON... command.

Thanks...
Paul

 

[jimstarr]

Hi Paul,

I'm not sure why you can't use ASCENDING/DESCENDING in the INDEX ON command, but those keywords are also available in the SET ORDER and SET INDEX commands.

Jim

 

[DEDMOD]

Just create two separate indexes on the table, one ascending and one descending with different names. Then use:

USE mytable
SET INDEX TO 'mytable.cdx' ORDER 1  && for first index or

SET INDEX TO 'mytable.cdx' ORDER 21  && for second index

Dave Dardinger

 

[DEDMOD]

make that ORDER 2, not ORDER 21

Dave

 

[paul060769]

Thanks guys. Great answers.

FYI -

INDEX ON exp1 TO <file> DESCENDING

ERROR!!!

This is a view. Can't seem to create any .cdx for it.

But, you guys did help us figure out the answer.

INDEX ON exp1 TO <file>

SET ORDER TO 1 ASCENDING
or
SET ORDER TO 1 DESCENDING

Thanks for the help...
Paul