>>We need to move a number of tables and DBCs around in order to accomodate multiple compainies in our accounting system.
>>Thanks a million to anyone who can help on this one!
>
>1) Run GenDBC[X] to get the definition of the database.
>2) In the output file from GenDBC[X], find each table and put the desired path relative to the database in each CREATE TABLE call.
>3) Loop through each table in the database (which you can get with
ADBOBJECTS()
) and append from the original locations.
Trey,
as I said Thanks a Million. I didn't even have to change the path. I guess because I have the search path set.
Beer is proof that God loves man, and wants him to be happy. - Benjamin Franklin
John J. Henn