Edit Tab

Use the options on the Edit tab to set preferences for browsing and editing data.

personal options edit tab, explained in the following text

Auto Switch

Select to automatically switch subordinate tables in a stack of two or more joined tables to display related rows.

When you select a row in a table and no related rows exist in the subordinate table, Edit automatically switches to display the next table in the stack that has a related row.

Display Column Attributes

Select to display column attributes (data type, length, and nullable attribute) for all columns in a selected table. Column attributes are useful when you insert a row or modify column data in the Table Editor.

Display Deleted Rows

Select to display rows that you delete (in Deleted status) in the Table Editor. Deleted rows appear dimmed. To hide deleted rows, clear this check box.

Single View

Select to disable the Join capability when the first item in the Table Editor is a view. Browsing and editing is more efficient by 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 to show column names and values side by side for a single row. To show column names and values for multiple rows (Columnar Display), clear this check box.

Warn on Cascade

Select to display a warning that rows in other tables might be deleted, or column values set to NULL, when you delete rows in a table. The Delete Confirmation dialog displays the names of affected tables, including tables that are not shown in the Table Editor. Column values might be set to NULL if the relationship between the tables is using the SET NULL delete rule.

Note: Be certain you want to disable this feature before clearing this check box.

Display NULL as Insert Default

Select to specify NULL as the default value for nullable columns when you insert a new row. If you clear this check box, Edit provides a value based on the column data type. Other than NULL, possible values include blank, zero, current date, current time, and current timestamp. To specify the character for the NULL value indicator, use the Display tab on the Personal Options dialog.

Note: Site management might set Product Options to restrict the use of this feature.

User Supplies Defaults

Select to require a user-supplied value for every column that cannot accept a default value. If you clear this check box, Edit provides a value based on the column data type. Possible values include blank, zero, current date, current time, or current timestamp.

Note: Site management might set Product Options to restrict use of this feature.

Prompt for Variables

Select to request a prompt for default values associated with substitution variables in an Access Definition. You can use substitution variables in selection criteria to specify data to browse or edit.

Retain SelCrit for Self-Ref Rels

Select 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 value can be changed on the Specify Edit Preferences dialog.

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

Auditing Active

Select to activate the Audit option for tracking database changes when you edit data. If you select this option, click Audit Tables to specify the tables you want to audit. If you prefer not to use this option, clear the check box.

Note: Site management might set Product Options to restrict the use of this option.

Audit Tables

Click to open the Audit Tables dialog on which you can specify a list of tables to audit.

Note: Auditing is available in Personal Options only if the Auditing Status in Product Options is set to Active/User.

Display Row Count

Specify the default number of rows to display for each joined table in the Table Editor. Use row count to manage the display area when you join several tables in the Table Editor.

Undo Levels

Specify the default number of times (1 - 20) you can undo a commit to any row in the Table Editor. You can specify the maximum number of undo levels (or commit points) per row.

Use undo commands to restore data in the Table Editor to a prior commit point. For example, if you change three columns in a row and commit that row, you can undo the changes by using one undo level. If you set Undo Levels to 5 and you commit seven times on a particular row, you can undo only the last five committed changes to that row or return to the original row.

Default Data Display

Select the default mode for adding tables to the Table Editor. Click the down arrow to select Browse, Browse Only, or Edit mode for each table opened or joined in the Table Editor.

In Browse or Edit mode, a table can appear only once in the Table Editor. In Browse Only mode, a table can appear more than once in the Table Editor.

You can switch from Browse Only mode to Browse or Edit mode by unjoining any duplicate tables, selecting Preferences from the Tools menu on the Table Editor, and selecting Browse or Edit mode.

Note: If the Force Browse Only check box on the Edit tab in Product Options is selected, the controls pertaining to editing data are unavailable.

Audit Tables Dialog

If you select the Auditing Active check box on the Edit tab, click Audit Tables to display the Audit Tables dialog. You can specify a Personal Options list of tables to audit.

Note: Auditing is available in Personal Options only if the Auditing Status in Product Options is set to Active/User. (See the Installation and Configuration Guide .)
audit tables dialog, explained in the following text

Optim Directory

Select the Optim Directory associated with the tables to audit. If you have access to more than one Optim Directory and want to specify the tables to audit for those directories, click the down arrow.

Audit results are stored in the PSTAUDIT table, which is one of the Optim Directory tables created when you install Optim. If you are authorized, you can browse or edit the PSTAUDIT table in the same way you browse or edit any other database table. However, Auditing Status in Product Options must be set to Active/User, and you must have database SELECT authority for the PSTAUDIT table.

You can specify a Personal Options list of tables to audit. However, the list specified in Product Options takes precedence over the list that you specify in Personal Options.

Table Name/Pattern
Enter the name of the database table or pattern that identifies the tables to audit. Table names consist of dbalias.creatorid.tablename.

When you specify a pattern for like-named tables, you can use percent (%) to represent one or more characters. Use underscore ( _ ) to represent a single character.

Note: An option on the General tab in Personal Options allows you to use the underscore as an SQL LIKE character.
Status
Enable or disable the Audit option for individual tables. Click to display a down arrow and select Enabled or Disabled for each table in the list.

If the status indicates Superseded by Product List, the table is ignored because of a conflict with the parameters set in Product Options. You cannot enable or disable the audit option for that table, but you can modify the table name or remove it from the list.

The Edit Process audits tables based on a number of specific parameters, beginning with the parameters specified on the Edit tab in the Product Options dialog.