Deleting a user-defined field
Deleting a user-defined field is a way of removing the field and any data that has been entered into the field. If you delete a user-defined field, the Asta Enterprise system's link to the field is removed, and the field and any data that has been entered into the field is removed from the database. Therefore, you cannot access the information that was entered into the field.
If you baseline projects from one data source into another and you delete a user-defined field from one data source, you must also delete it from the data source into which you baseline projects, as both data sources must have the same user-defined field structure.
If you delete a user-defined field that is referenced by an OLE automation routine, an error message will be displayed when you try to use the OLE routine.
To delete a user-defined field:
- In the left-hand pane, select the data source from which you want to delete a user-defined field, then select the User Defined Fields folder. The user-defined fields that have been added to the data source are listed in the right-hand pane.
- Select the user-defined field you want to delete.
- Select User Defined Fields from the Custom menu, then select the Delete command. You are asked to confirm that you want to delete the field.
- Click Yes
to confirm the action. The selected field is deleted.
If you are deleting a user-defined field from a type of data source other than direct connection (ADO), the user-defined field deletion process is complete. If you are deleting a user-defined field from a direct connection data source, a dialog appears asking if you want Server Admin to generate a SQL file that you can run to delete the user-defined field from the data source. - Click Yes to create a SQL file, or click No if you do not want to create the SQL file. If you choose not to create a SQL file, you will have to delete the user-defined field from the data source manually.
- If you choose to create a SQL file, enter a path and file name for the file.
- Enter exit at the Enterprise server command prompt to shut down the server.
- Execute the SQL file that is output in Query Analyzer to delete the user-defined field from the data source.
- Restart the Enterprise server.