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.
>>
If it's not broken, fix it until it is.
My Blog