You didn't mention what problem you've got, so I assume that it was the

SELECT (0)

line, since it gave me an error. What about

USE pplines ALIAS ppl IN 0
SELECT ppl

HTH

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