>>>>Hi all,
>>>>
>>>>I am attempting to copy the structure of one table to another. But when I execute the following command I get the error "Object name is invalid". I know it has to do with the database or the long field names in the table. What could be cuasing this?
>>>>
>>>>

>>>>COPY STRUCTURE TO "new.dbf" DATABASE myDatabase WITH PRODUCTION
>>>>

>>>
>>>Skip the apostrophes!

>>>COPY STRUCTURE TO new.dbf DATABASE myDatabase WITH PRODUCTION
>>>

>>
>>I would, but the table name has spaces.
>
>If it is in VFP environment you can use something like
>
>**open/select table you wanna propagate
>

>COPY STRUCTURE TO (getfile('dbf')) DATABASE (getfile('dbc')) WITH PRODUCTION
>

>
>This is interactive way to propagate table. If you need it in APP then you could have parameters stored in variables and then use
>something like ;
>

>use mySourceDbf
>select mySourceDbf
>cTargetDbf='c:\test\myTarget.dbf'
>cTargetDBC='c:\test\test.dbc'
>COPY STRUCTURE TO (cTargetDbf) DATABASE (cTargetDBC) WITH PRODUCTION
>

>
>HTH
>Sergio

Thanks.