Edit Window
Each table selected for display in the Table Editor is displayed in an edit window. Each edit window contains display options and menu choices that pertain to the corresponding table.
Note: Binary data is not displayed.
Cells containing binary data are shaded. To view binary data, use
the hexadecimal display. For more information about viewing and editing
binary data, see Edit Data. Also, numeric SQL variant
data is displayed as binary.
An edit window contains the following components:
- Table
- Displays the name of the table shown in the edit window. If the table name is not fully qualified, the default qualifier is assumed.
- Toolbar
- Select
actions or options from the edit window toolbar for the table in the
edit window, as follows:
- Format or
- Switch between columnar and side label format. Refer to Display Options.
- Undo
- Undo changes to all rows in the current fetch set for the table. Refer to Commit and Restore Data for details.
- Options
- Display the edit window Options menu. Refer to "Edit Window" for additional information.
- Join
- Join an additional table in the Table Editor. The additional table must relate to the table in the Table Editor. If a relationship does not exist, Edit prompts for the information to create a relationship. If more than one relationship exists, you select from a dialog that contains a list of the relationships. Refer to Display Multiple Tables for additional information.
- Unjoin
- Remove the table and all subordinate joined tables from the Table Editor. See Display Multiple Tables for additional information.
- Refetch Rows
- Retrieve a
new fetch set of rows for the table. If other users are simultaneously
accessing this data, refetch rows periodically to ensure you have
current data. Note: You can undo changes to the current fetch set only. If you refetch rows, you cannot undo changes to the previous fetch set. See Commit and Restore Data for additional information.
- Mode or
- Switch between Data mode and Expression mode.
For Data mode, all editing is committed as entered. For Expression mode, all editing is evaluated before it is committed. Click Evaluate Expression on the shortcut menu to evaluate expressions before committing to the database.
- Navigation
- Scroll side label display to the first row, previous row, next row, or last row, respectively.
- Format
- Filtering
- Indicates whether Table Specifications, such as Selection Criteria, are defined for the table. Filtering OFF indicates no criteria are defined.
- Join Arrow
- Position the Join
Arrow to display related rows in joined table(s). See Display Multiple Tables for additional information.
To move the arrow to a different row, click the Join Arrow grid column in the desired row or use the up/down arrows on your keyboard.
Note: The Join Arrow grid column and the Status grid column are shown when a table is displayed in columnar format only. See Display Options for additional information. - Status
- Indicates
the status of each row, as follows:
- blank
- The row in the current fetch set has not changed.
- Untouched
- The row in the current fetch set has not changed (Side label display only).
- Updated
- The row has changed and is committed to the database.
- Updated(*)
- Changes to the row have been undone, except for LOB data changes, which cannot be undone.
- Pending (Upd)
- The row has been updated or changed, but the change is not committed to the database.
- Pending (Ins)
- The row has been inserted, but has not been committed to the database.
- Inserted
- The row is new and has been committed to the database.
- Deleted
- The row has been deleted.
- Evaluated
- Expressions in the row have been evaluated and are acceptable.
- Error
- The row contains at least one error. Refer to the message bar of the dialog for more information.
- Locked
- If Edit cannot display the new version of an updated
or inserted row, the row is placed in Locked status. This situation
can occur when a database trigger modifies the row before it is inserted
into the database. Position the pointer on the status grid cell of
a locked row to display the reason the row is locked.
Click the Refetch Rows button on the edit window toolbar to acquire a new fetch set to display the committed versions of the updated or inserted rows. If the Audit Tables option is active, the row is not committed.
Edit Window Options Menu
Use the edit window Options menu to select edit and display options for the table in the corresponding edit window. You can switch between Edit and Browse modes, choose various display options, and select other table specifications, as described in the following paragraphs.
Preferences you select on the Options menu apply to the corresponding edit window only.
Note: If the Force
Browse Only check box on the Edit tab
in Product Options is selected, the controls pertaining to editing
data are disabled. (Refer to the Installation and Configuration
Guide. )
Click
the Options button 
in
the edit window toolbar to display the edit window Options menu.
- Browse
- Switches between Browse mode and Edit mode for the corresponding table. This selection is unavailable if Browse Only is selected for the default data display.
- Display Attributes
- Switches between including or excluding column attribute information in the column headings.
- Display Deleted Rows
- Switches between displaying or hiding rows that you delete from this table. Deleted rows appear dimmed when displayed.
- Table Specifications
- Opens
the submenu to allow you to set table specifications. Table specifications
are part of the Access Definition. Table specifications allow you
to limit the amount of data obtained from the database in a fetch
set. The available table specification options are as follows:
- Columns
- Set the display mode and create column associations for Large Object (LOB) columns. Associations correlate the type of object with the appropriate application to use for editing.
- Selection Criteria
- Specify selection criteria for one or more columns to limit the data to fetch from any table.
- SQL
- Create an SQL WHERE clause to define complex selection criteria for one or more columns in any table to limit the data to fetch.
- Sort
- Select sort criteria to arrange rows in ascending
or descending order for one or more columns, in order of priority.Note: Refer to the Common Elements Manual for complete information and details about table specifications.
- Reset
- Opens the submenu to allow you to reset the table specifications to the original settings.
- Show SQL
- Displays a dialog containing the SQL used to obtain the fetch set. You can use the SQL dialog to review, print, and save SQL used to retrieve the current fetch set for the table in the active Edit Definition. To save or print SQL, select the appropriate command from the File menu on the SQL dialog.
- Insert Row
- Creates a blank grid row for data entry to add a new row to the table in the database. The blank grid row is inserted after the last displayed row in the edit window.
- Show Excluded Rows
- Displays all rows previously excluded from the table (rows are excluded using the shortcut menu Exclude command). To display excluded rows individually, right click a row and select Show Next from the shortcut menu.
- Remove Locked Rows
- Removes rows in Locked status from the display and allows you to continue to edit the current fetch set.
- Undo Errors
- Removes changes to rows in the table that result in an error condition. See Commit and Restore Data.
- Undo Last
- Removes the last change to the table. See Commit and Restore Data.
- Rows meeting Criteria
- Displays a message to indicate the number of
rows that meet the selection criteria. You can choose to increase
the fetch limit for the table up to the maximum established in Product
Options.
For example, when the number of rows that satisfy the criteria is 711, but the fetch limit is 500 and can be increased, the following is displayed:
However, if the fetch limit is at maximum, the following is displayed:
- Unsupported Columns
- Indicates there is at least one unsupported data type in the table. Select Unsupported Columns to display a dialog that contains a list of the unsupported columns and the corresponding data type for each.