Is it possible to remove redundant fields from the system. I have a whole bunch of fields which I was using for temporary data storage, but they are no longer referenced.
Subject: Redundant fields
The correct way for removing not wanted fields from the UNK table was described in the March/April 2003 issue of The view. http://www.eview.com/
- Delete the field from the form by click to the right of the field and backspace over it. You should be prompted to delete the field.
Do NOT delete a field simply by pressing the Delete-key - this will not remove the fieldname from the UNK table.
-
For an application db that is in production: Write an agent to delete unwanted or obsolte fields from the document. You can use a simple Formula agent like FIELD oldfield := @DeleteField; or FIELD oldfield := @Unavailable;
-
Remove all references to the deleted fields from views, buttons, agents and so forth
-
Remove any definitions for deleted fields that may be hanging around in forms. If You have deleted fields without beeing prompted to verify the deletion then You can delete the field from the UNK table by re-create a new textfield with the same name and click to the right of this field and backspace over it.
-
Delete the full-text index.
-
Compact the database
-
Recreate the full-text index (if appropriate).
That should do it.
hth
Subject: Redundant fields
In general you need to write an agent to remove those fields and run it on all the documents where those fields exist.
Stephen Lister