how do i remove all those unused fields that i’ve already deleted but still remained in the view, programmer’s pane(field)??
I’ve search similar topics but i don’t understand… pls gif me a detailed explanation. thx!
Subject: remove unused fields: What worked for me
In case it’s useful to someone, here is what worked for me.
- Agent to delete the field names from all docs
Field obsoleteFieldName := @Unavailable;
- Delete the field name from the relevant forms.
To Check: from the designer right-click the form name and click “Design Properties”. On the properties look at the fields on the form. If you still see your field listed although it’s no longer on the form then re-edit the form, create a field of that name on the form, exit and save the form, then edit it again, delete the field, and re-save the form (I had renamed the fields and there were references to some of the old names still there - when I did this sequence they disappeared)
-
Remove the Full Text index from the database
-
From the console do a
load compact path\DbFilename.nsf -c (this performs a copy compact on the db)
(a copy compact from the Administrator client may also work - but I did it this way)
Notes:
I had done 1), 2) and 4) but it didn’t work. When I did 3) it worked (I can no longer see the old field names when I open a view in designer).
I did this in order to change the case of the field names (this particular bunch of field names all began with LL in lowercase, before I changed them)
Subject: remove unused fields
you should run an agent for all documents with the following formula:
FIELD name_of_the_field := @DeleteField;
when none of the documents in the DB have this field, will not be available anymore.
AFAIK…
be carefull because if you point to a good field… you’ll be f*%$ed.
Subject: RE: remove unused fields
And then you must do a copy-compact.
Subject: remove unused fields
running Compact against the db will remove the field names from the list, assuming:
No design elements reference the field name(s)
No documents reference the field name(s)
Subject: remove unused fields
Good question, I hope someone post a better way
The only way I know of doing it is create a new blank database and then copy over the design elements you want. Therefore any fields you created and since deleted will not be on the list.
Subject: remove unused fields
If I remember correctly, you add a field of the same name to your form, save, then click on the field - do not select it - and press Delete. Save the form.
If you select the field and press Delete it hangs around, as you see.
I don’t remember if you have to compact.