Moving PFIELDS between modules

Chris Kelleher

Administrator
Staff member
Greetings,

I've got myself into a little knot...

Here are the rough steps that have been done to date:
We wanted to merge a workspace into another workspace. IOW, bring all programs and data definitions
(from workspace SI) into an existing workspace (workspace IM).

We set the workspace sources in IM to look at the original workspace (SI) and created an import.
Everything was imported.

Created a group check out to move the PCODE to the correct modules (from module si-bat to im-bat) so
that all the source code will be in the same module.

Created a new module im-dbsi and did a "Load Schema" from the physical database. This is where
things have gone wrong.

The table names were created in im-dbsi and new table.fields that had been created in the database
due to some tables having the same name as in other databases already in the workspace.

The situation is this:
Table names in im-dbsi (new module created) with some fields.
Field names in si-dbm (old module) that was imported into new workspace without table names.
When expanding the table in im-dbsi, all the fields are displayed with Pmodule of si-dbm.


How can I move all the fields to be in im-dbsi? Or maybe move the tablenames back to si-dbm? Does
anyone understand what I've done?
I tried assigning or creating the fields again, but I get an error stating that that name exists
already. Anything else I should try?

Any help in untying this knot would be appreciated...

Regards,
Stefan


-------------------------------------------
Stefan Le Jeune
MIP Holdings
Cape Town, South Africa
+27.21.403-9555(Work)/+27.83.462-1766(Cell)
stefan@mip.co.za
 

Chris Kelleher

Administrator
Staff member
Stefan,

I will make an attempt in understanding what you have done and then suggest
a course of action.

When you loaded a second database the pmodule of the database was set to
si-dbm and therefore all of the tables and field belong to that pmodule.

Assuming the database is large and you don't want to manually move the
fields from one pmodule to the other I would probably suggest restoring from
a backup that occurred before this load.

Otherwise, you could set up a windows macro to delete all of the object on
the task that loaded the database and start over.

Wish I had better suggestions.

Nathan Noll (817) 284-8680
NCS Fax (800) 538-7510
Certified Roundtable Consultants nathan@nollc.com

Check out F1 an integrated Change Request System that works
with Roundtable! www.nollc.com/f1
 
Top