Does this work?

CREATE TABLE (lcFilename) FREE ( contract_id C(12), service_id C(12), ;
     sub_id C(3), startdate D, enddate D)

Or maybe I am blind today as well :o) Are your field names longer than 10 chars? Wouldn't be the first time for me...



>Hi All,
> I am blind today. I have the following in code and get the error "Field name is a duplicate or invalid" when it hits the create table line. lcFilename is a valid path and new table name, no table by that name in the directory.
>

>  lcFilename = gPrintTables + "trnsct3.dbf"
>  ...
>  CREATE TABLE (lcFilename) FREE ( contract_id C(12), service_id C(12), ;
>     sub_id C(3), startdate D(8), enddate D(8) )
>

>
>Can someone tell me, please, what I am missing? It looks the same as four other lines I have in other progs.
>
>TIA
>Beth