Interesting idea. Didn't occur to me. Let me give it a try...
Ok, have problems because we have views based on views and GenDBC doesn't put them in the right order in the generated code so it can't find the source view when the resulting PRG is run. The process I'm working must run without intervention, so I'm not sure GenDBC is going to work.
>If you are trying to replicate a DBC and all its tables, you may want to have a look at GENDBC. It is a PRG you run against an existing DBC, and it creates a PRG that, when run, will recreate the DBC with all tables, relations, indexes, etc. The resulting tables will all be empty, but you could then spin through the tables and APPEND FROM the originals. As long as you don't have complex RI code, this approach should work.
>
>>I'm getting this error when tring to remove a table from a database programmatically. How do I delete the relation in code so I can remove the table? This whole database container, back links, front links, belongs to crap is killing me. This routine was supposed to take about 4 hours and it's been 3 days. All I'm trying to do is copy a source database and tables using the COPY TO command and it's been a nightmare. Almost there, but everytime I think that, another one of these errors bites me in the patootie.
>>
>>
>>
>>Table "name" is referenced in a relation (Error 1577)You cannot remove a table from a database if that table is involved in a relation.
>>
>>Delete the relation first.
>>
>>