See CREATE FROM in Hacker's Guide. I have not read it yet...
>Hi Steve,
>
>The strange thing is, what this code was working correctly for more than a year. Only today I found this strange thing. Does your other suggestion with copy to command properly copy all things (field rules/table rules)?
>
>>Nadya,
>>
>>No problem...I'm eating lunch anyway.
>>
>>I can't find it documented in VFP help or in Hacker's Guide. Also, I haven't figured out how it handles the DATABASE keyword. If I leave that keyword out, it will prompt me to overwrite an existing file. If I leave it in, I get an error on the second attempt at creating the same file name. However, the new table does not appear to be actually added to the DBC.
>>
>>You could go with my other solution (the COPY TO command), or take out the DATABASE keyword. Then add the new table to the DBC (if it is not there).
>>
>>>>Oops...I didn't notice that you weren't using CREATE TABLE.
>>>>
>>>>CREATE gives an error of the table you are trying to create already exists in a database...
>>>
>>>Hi Steve,
>>>
>>>Sorry for bothering you again. Where did you find the description of this command in Help? I just can not. CREATE command Help doesn't show DATABASE keyword, etc.
>>>
Steve Gibson