PDA

View Full Version : Moving Tables between Workspaces



Joe Coley
22-Feb-2005, 01:38 PM
I have 3 tables and some related views and reports defined and created in
one workspace. I want to also have them available (add them) into another
workspace with a completely different set of tables, and then probably
"tweak" the reports and views. I don't want to have to create from scratch.
I have tried doing this in the past with terrible results --seems something
always gets out of sync and I can't compile etc. I'm missing something.

What is the procedure that should be followed here to gaurantee useability
of "moved" tables, views, reports etc.?

pm3bob
22-Feb-2005, 04:28 PM
FWIW ... I do this with few problems ... once I accepted the fact that they
had to have the same "File Number" in both workspaces. If you don't do that
you'll have a nightmare keeping track of FDs mainly.

What I've done is put "common tables" in a directory that is in the data
path of both workspaces. If, for some reason, you put the tables into
multiple workspaces, remember that DF will find the one listed first in the
path.

"Joe Coley" <jcoley@kamconewengland.com> wrote in message
news:LFup22QGFHA.1952@dacmail.dataaccess.com...
> I have 3 tables and some related views and reports defined and created in
> one workspace. I want to also have them available (add them) into another
> workspace with a completely different set of tables, and then probably
> "tweak" the reports and views. I don't want to have to create from
scratch.
> I have tried doing this in the past with terrible results --seems
something
> always gets out of sync and I can't compile etc. I'm missing something.
>
> What is the procedure that should be followed here to gaurantee useability
> of "moved" tables, views, reports etc.?
>
>