>I'm hoping I'm missing the boat on a much easier way to accomplish this task, and hope someone here can point me to an easier way to accomplish the following.
>
>Currently, if I need to "copy" the structure of a view or table from my test dbc to my live dbc, I have to open the development view, list view to a text file, open the text file (for reference), then open the live dbc, and using the information in the text file I generated, manually re-create that view or table in the corresponding designer. I know I could use the information in the text file to build a create view or create table statement, but that takes nearly as long to do as opening the designers to do the job.
You can use GENDBC utility to create a program which programmatically recreates your database and then just copy and run the part which recreates the view. There are also some utilities in Files section which can help you with the view code.
>I know with a table, I could simply do a copy struc to a free table, but if I do this, the table is constrained to the limitations of field name sizes, file name length, etc.... that dbc's do not have.
>
For the table just use
COPY TO FileName DATABASE myLiveDBC WITH CDX
(you can provide the full path to your DBC)
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro
"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison