Edit Preferences

(For full details on edit preferences in Personal Options, refer to the Common Elements Manual. )

Use this dialog to specify preferences that override edit preferences selected in Personal Options. Preferences you select on the Specify Edit Preferences dialog apply to all tables in the currently opened Table Editor only.

Auto Switch

Select this check box to automatically switch subordinate tables in a “stack” of two or more joined tables. When you scroll and no related rows exist in the displayed subordinate table, Edit automatically switches to display the next table in the stack that has at least one related row.

Display Column Attributes

Select this check box to include column attributes with the column heading. This information is useful when inserting a row or determining column dimensions.

Display Deleted Rows

Select this check box to display rows you delete (deleted rows appear dimmed). Clear this check box to remove deleted rows from the display.

Single View

Select this check box to disable the Join capability when the first item in the Table Editor is a view. Browsing and editing is more efficient using Single View mode because relationship information is bypassed. However, to browse or edit related data, you must clear the check box.

Side Label Display

Select this check box to display all tables in the side label format. You can toggle between side label format and columnar format for individual tables using the edit window toolbar. See Display Options.

Warn on Cascade

Select this check box to display a warning when you delete rows in the active table. Rows in other tables may be deleted or column values set to NULL (if the relationship between the tables uses the “SET NULL” delete rule) when you delete rows in the active table. The Delete Confirmation dialog displays the names of affected tables including tables that are in the Table Editor.

Note: Consider the potential consequences before you disable this warning. A Delete action can affect rows that are not displayed or currently active in the Table Editor. Data deleted from tables that are not active in the Table Editor cannot be restored.

Use NULL as Insert Default

Select this check box to specify NULL as the default value for null eligible columns when you insert a row. Clear the check box to direct Edit to insert a default value other than NULL. The inserted value depends on column data type and includes blank, zero, current date, current time and current timestamp.

Note: Site management may set Product Options to restrict the use of this function.

User Supplies Defaults

Select this check box to require user‑supplied values for every column that cannot accept a default value. Clear the check box to specify that Edit inserts a default value. The inserted value depends on column data type and includes blank, zero, current date, current time and current timestamp.

Note: Site management may set Product Options to restrict the use of this function.

Prompt for Variables

Select this check box to display the prompt string for a value for each variable before the fetch set is obtained, regardless of whether or not a value has been assigned. Clear the check box to display the prompt string only when a value for a variable has not been assigned. (This menu command is applicable when there are substitution variables specified in the Access Definition.) Refer to the Common Elements Manual.

Retain SelCrit for Self-Ref Rels

Select this check box to apply selection criteria each time a table is self-referenced in the Table Editor. Clear the check box to ignore selection criteria when a table is self-referenced. The default setting for this option is specified in the Edit tab of the Personal Options dialog. Refer to the Common Elements Manual for more information.

Note: A table can be self-referenced only when the Table Editor is in Browse mode.

Display Row Count

Specify the maximum number of rows to display from the fetch set for each table that has tables joined to it. Click Defaults to use the Display Row Count value specified on the Edit tab of the Personal Options dialog.

Undo Levels

Specify the number of times (1 to 20) you can undo a commit to any row in an active Edit Definition. The number of undo levels may affect the performance and speed of Edit.

An undo level is defined as a change to a row that is committed to the database. However, if a change to a row results in an error condition, the change is not committed to the database, but still counts as one undo level.

Click Defaults to use the value specified on the Edit tab of the Personal Options dialog.

Default Data Display

Browse

Select this check box to choose the Browse mode by default for each new table joined to the Table Editor. You can switch to Edit mode using the edit window Options menu for individual tables, as required.

Browse Only

Select this check box to choose the Browse Only mode by default for each table added to the Table Editor. You cannot switch to Edit mode using the edit window Options menu.

Edit

Select this check box to choose the Edit mode by default for each table added to the Table Editor. You can switch to Browse mode using the edit window Options menu for individual tables, as required.

Command Buttons

OK

Click OK to save and apply the selected preferences to any new tables you join, but not to the tables currently in the Table Editor.

Cancel

Click Cancel to close the dialog without applying or saving changes to the Edit Preferences.

Apply

Click Apply to apply and save the selected preferences to tables in the Table Editor and any new table you join.

Defaults

Click Defaults to return Edit Preferences to the default settings (specified in Personal Options).