Try OpenEdge Now
skip to main content
Basic Database Tools
Schema Menu Reference : Field Editor option

Field Editor option

Use the Schema > Field Editor menu option to modify schema definitions for a field. When you choose this option, the Field Editor alphabetically lists all the tables defined for your database. When you select the table you want to edit, the Field Editor lists all the fields defined for the selected table. The following figure shows the fields defined for the customer table.
Figure 27. Field Editor window
You can add, edit, delete, or view field attributes defined for the current table from the Field Editor. The following table describes the options for the Field Editor.
Table 10. Field Editor options
Displays the next page of fields.
Displays the previous page of fields.
Adds a new field.
Updates field attributes.
Note: You can modify the Data Type field only if the field is an integer and you want to change it to INT64. For all other data types, the field is read-only. For more information, see Changing a field data type from integer to INT64.
Deletes a field.
Copies fields from table definitions.
Defines or modifies triggers.
Defines the View-As phrase for field widget type.
Defines or modifies string attributes.
Opens the Index Editor.
Switches to a different table.
Displays the field attributes.
Toggles between displaying fields in alphabetical order or in the order defined by the values in their _Order fields. The Field Editor displays a message at the bottom of the window indicating how the fields are currently ordered.
Undoes any changes you made to the field attributes for this Field Editor session.
Saves your changes, exits the Field Editor, and returns to the Data Dictionary Main Menu.
To use the Field Editor, choose an option, then select the field you want to edit. The following sections describe the Add, Triggers, View-As, and GoIndex options in more detail.
* Add
* Field Triggers
* View As
* GoIndex option