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