Table Editor Components

The Table Editor displays one or more related tables, each in an edit window. Each table relates to the table displayed in the edit window above it.

The components of the Table Editor allow you to describe the Edit Definition, add tables to the display, manipulate and choose preferences for the display of each table, and perform functions on tables individually or collectively.

The Table Editor can have several edit windows open, depending on how many tables are joined.

The Table Editor includes the following details:

Description

Enter text to describe the set of tables edited or browsed (up to 40 characters).

Default Qualifier

The default qualifier is the two-part prefix used to qualify any unqualified table names in the Table Editor.

Cancel Button

The cancel button is enabled when data is being fetched from the database. Click Cancel to halt the fetch operation. If you cancel the fetch operation, an incomplete fetch set is obtained for the table in progress. Empty fetch sets result for tables subordinate to the table with the incomplete fetch set. A message appears in the status bar for each table involved in the cancel operation.

Edit Window

The Table Editor displays each table in an edit window. Refer to Edit Window for details.

Tools Menu

In addition to the standard File, Edit, and Tools menu commands, you can select the following commands from the Tools menu.

Preferences: Displays the Specify Edit Preferences dialog. Refer to Edit Preferences for additional information.
Convert AD to Local: Converts a named Access Definition to a local Access Definition.
Note: A local Access Definition is stored with the Edit Definition and is available only to that Edit Definition.
Respecify Variable Values: Modifies the default values assigned to substitution variables in an Access Definition. This menu command is available only if there are substitution variables specified in the Access Definition. Select this command to open the Variable Values dialog, modify the variable values, and automatically obtain a new fetch set. For complete information, refer to the Common Elements Manual.
Indent: Lists the names of multiple joined tables in the Table Editor in an indented format. Refer to Display Multiple Tables.
Undo All: Removes changes to all rows in the current fetch set for all displayed tables. Refer to Display Multiple Tables for details.
Undo Errors: Restores rows in error to the last valid state, for all displayed tables. Refer to Commit and Restore Datafor details.
Show Excluded Rows: Displays all rows previously excluded from all tables using the shortcut menu Exclude or Include options. Refer to Locate Specific Data for information about display options.