Deletion of obsolete fields - They're still there!!!!!

[David Palm]

While I was doing the design for a new database I moved a few fields
in the forms design pane using CTRL+C - CTRL+V (copy and paste...)
after wich I deleted the original field and renamed the new one. This
was quite stupid (should have used CTRL+X instead...), as I now have
copies of various fields in my database. These fields are not used in
any of the documents (I'm sure of that because I've deleted all the
documents... Extreme Frustration brings fourth Extreme Measures...),
and they are not visibly present in any of my forms, but they are
still there! When I visualize the properties for my forms (Fields
tab...) I can still see them. How must I do to delete them definitely
from the database? ARRRGHHH!!
Thank you in advance,

David Palm
Information to the Citizen
Municipality of Bologna
Italy

[R.G. Spencer]

Our general plan is to copy and paste the entire form to a new database.
It seems to get rid of the phantom fields. It would be nice to have a
definitive procedure.
Ralph

[jfu...@thenetguru.com]

David Palm wrote:
>
> While I was doing the design for a new database I moved a few fields
> in the forms design pane using CTRL+C - CTRL+V (copy and paste...)
> after wich I deleted the original field and renamed the new one. This
> was quite stupid (should have used CTRL+X instead...), as I now have
> copies of various fields in my database. These fields are not used in
> any of the documents (I'm sure of that because I've deleted all the
> documents... Extreme Frustration brings fourth Extreme Measures...),
> and they are not visibly present in any of my forms, but they are
> still there! When I visualize the properties for my forms (Fields
> tab...) I can still see them. How must I do to delete them definitely
> from the database? ARRRGHHH!!
> Thank you in advance,
>
> David Palm
> Information to the Citizen
> Municipality of Bologna
> Italy

Try writing an agent using script. You can easily delete test to see if
the field value is null and if so, delete it from the document.

Cheers - John

[Daniel Hernandez]

Hi there,

If the fields are still present in old documents, they'll show up in the
list of fields. I've noticed that some old legacy fields tend to stay
around until one compacts the database.

danny

[George Schoofs]

have you tried compacting the database?

David Palm <voc...@iperbole.bologna.it> wrote in article
<33f97b5e...@news.iperbole.bologna.it>...

[Scot D Haberman]

This is an issue with Lotus. We have tried everything to get the fields to
disappear and nothing worked. We contacted Lotus and they are working on
it (so they say). It is a bug that they have acknowledged.

David Palm <voc...@iperbole.bologna.it> wrote in article

<3401ad8a...@news.iperbole.bologna.it>...
> >One thing that I have noticed is even if you delete ALL documents in the
> >database, phantom fields can still exist in the form designs. In one
case,
> >I selected everything on the form and deleted it, including all script,
and
> >the form still showed phantom fields in the properties box.
>
> This is what I am experiencing! COMPACT, FIXUP and other serverside
> operations didn't help at all (and I did try to delete all documents
> in the database, and I also tried to make an empty copy of the whole
> thing...)
>
> >I was only able to remove these by using a cut and paste method of all
the
> >form design contents to a new form.
>
> Guess I'll have to try this now...
>
> Bye, and thanks for all kind replies!
>