>>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.
>
>"contract_id" is 11 characters, longer than limit of 10 for free tables.
>
>Another useful tip is to not include lengths for field types such as Date, Datetime, Integer etc. which have only one possible length e.g. use
>

>... startdate D, enddate D ...
>

>This avoids any chance of errors caused by typing in the wrong size, mismatching parentheses etc.

I Knew I was blind. Duh. :)

Thanks for pointing out my problem.

Beth