Archived PFIELD

[Chris Kelleher]

Hi all

Can anybody help a Roundtable newbie...

I have a table with a number of fields that have a status of 'Checked in
(Archived)'. These fields where deleted in error and I now need to get these
fields back. The progress table has been restored in the physical db but the
roundtable schema needs updating. I have tried using 'Update schema' but
this gives me a build error and will not let me proceed. If I go to the
rooundtable table and try to assign the previous version of the fields (ie
undelete them) I get message saying that I dont have a WIP status and to
check out the field. The problem is I can't check these fields out
presumably because of their archived status.

Any ideas.

Dave

===========================================
Dave Evans (DBA/Systems Development)
E-mail daveevans@rapid-systems.co.uk
===========================================

 

[Chris Kelleher]

1) To get around the build error, use 'skip' in the build process to reset
things.

2) If your physical(workspace db) is still correct then
(I am not sure if you are using windows) right mouse click on the db object
and import schema. This will import your workspace schema into the
repository.

-----Original Message-----
From: Dave Evans [mailto:daveevans@sswholdings.com]
Sent: Monday, October 18, 1999 5:33 AM
To: roundtable@peg.com
Subject: Archived PFIELD


Hi all

Can anybody help a Roundtable newbie...

I have a table with a number of fields that have a status of 'Checked in
(Archived)'. These fields where deleted in error and I now need to get these
fields back. The progress table has been restored in the physical db but the
roundtable schema needs updating. I have tried using 'Update schema' but
this gives me a build error and will not let me proceed. If I go to the
rooundtable table and try to assign the previous version of the fields (ie
undelete them) I get message saying that I dont have a WIP status and to
check out the field. The problem is I can't check these fields out
presumably because of their archived status.

Any ideas.

Dave

===========================================
Dave Evans (DBA/Systems Development)
E-mail daveevans@rapid-systems.co.uk
===========================================

 

[Chris Kelleher]

Dave,

Usually with a build error additional error information is provided. I
suspect the Build error is because not all of the fields associated with the
updated table have been restored. Assign all the field objects and then run
your update schema. If you have a different error, please let me know.

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
-----Original Message-----
From: Dave Evans <daveevans@sswholdings.com>
To: roundtable@peg.com <roundtable@peg.com>
Date: Monday, October 18, 1999 5:41 AM
Subject: Archived PFIELD


>Hi all
>
>Can anybody help a Roundtable newbie...
>
>I have a table with a number of fields that have a status of 'Checked in
>(Archived)'. These fields where deleted in error and I now need to get
these
>fields back. The progress table has been restored in the physical db but
the
>roundtable schema needs updating. I have tried using 'Update schema' but
>this gives me a build error and will not let me proceed. If I go to the
>rooundtable table and try to assign the previous version of the fields (ie
>undelete them) I get message saying that I dont have a WIP status and to
>check out the field. The problem is I can't check these fields out
>presumably because of their archived status.
>
>Any ideas.
>
>Dave
>
>===========================================
>Dave Evans (DBA/Systems Development)
>E-mail daveevans@rapid-systems.co.uk
>===========================================
>