Renaming Field Definitions

You can use either the Rename Definition dialog box or the Open Definition dialog box to rename a field definition.

Using the Rename Definition Dialog Box

To rename a field definition from the Rename Definition dialog box:

1. Select File, and then Rename to open the Rename Definition dialog box.

2. Select Field as the definition type.

3. Enter the name of the field.

   If you are not sure of the name or the correct spelling, use the search criteria fields to locate the field to rename. The list displays field names that match your search criteria.

4. To rename a field in the list, select the field and click Rename or double-click the field.

   The field name becomes available for entry, and you can enter a new name.

5. When you finish typing the new name, press enter or click the Rename button.

   The Rename Field dialog box appears. Select the records in which you want the field to be renamed. The De-select All button toggles to Select All.

6. Click OK.

Using the Open Definition Dialog Box

To rename a field definition from the Open Definition dialog box:

1. Select File, and then Open to access the Open Definition dialog box.

   This dialog box enables you to set up search criteria for locating field names.

2. Select Field as the definition type.

   If you have additional information, use the Name field. You can further narrow your search criteria by selecting a field type or the name of the project that contains the field to delete.

3. Click the Open button or press enter when you have completed your search criteria.

4. You can rename a field in the Open Definition dialog box by selecting the field, right-clicking the field name, and selecting Rename.

   You can also select the field name and click it a second time. The field name becomes available for entry and you can enter a new name.

5. When you finish typing the new name, press enter or click the Rename button.

Results of Renaming Field Definitions

When you rename a field, the system automatically changes all occurrences of it, including data in tables with columns named FIELDNAME where the data matches the field being renamed.

The only references that are not renamed are the text portions of SQL functions, such as SQLExec and ScrollSelect. If you already used SQL Create to create the underlying tables for the record definitions that contain the field that you renamed, you must recreate or alter those tables. If the tables contain data that you want to preserve, use the SQL Alter function to rename the database table fields.