Hi John,

You didn't say what the problem is, so I can only guess.
Don't trim HrsName or you could get an error because field lenght cannot be 0.

INDEX ON HrsName + StrDate DESCENDING TAG HrsName

>Hi
>
>Could someone please help. I have code to create a table on the fly as follows.
>

>    CREATE TABLE "pplines.dbf" ;
>      ( PPRaceID  C(13), ;
>        PPTypeID   C(9), ;
>        StrDate    C(8), ;
>        HrsName    C(18), ;
>        RaceDate   D, ;
>        DSLR       N(4), ;
>        Track      C(3), ;
>        TrackCond  C(2) )
>
>    INDEX ON TRIM(HrsName) + StrDate DESCENDING TAG HrsName
>
>Then I have code:
>
>SELECT(0)
>use pplines alias ppl
>SET ORDER TO TAG "HrsName"

>What am I doing wroung.