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.