Optim™ performs a
cascading delete/update check when you save an Access Definition or
execute a process. If a cascading delete or update may affect a table
that is not explicitly referenced in an Access Definition or a process,
the Cascading Delete/Update Confirmationdialog
is displayed.

The Cascading Delete/Update
Confirmation dialog lists the names of all tables for which rows may
be deleted or updated because of deletes or updates to the parent
table. This dialog is provided for information only and cannot be
modified.
Note: The
Warn on Cascade Delete/Update setting
in Product or Personal Options determines the display of this dialog.
See
General Tab in this manual or Product Options in the
Installation
and Configuration Guide for further information.
In Scope
When
selected, the In Scope box indicates a table
is explicitly included in the Access Definition or process. When cleared,
it indicates a table is not explicitly included in the Access Definition
or process.
Note: The Cascading Delete/Update Confirmation dialog
is displayed if the In Scope box is cleared.
Delete Rule
Delete
Rule indicates the rule for deleting from the child table when
a row in the parent table is deleted or updated.
- Cascade Delete
- All child rows are deleted when the parent row is
deleted.
- Cascade Set Null
- Foreign key columns are set to NULL when the parent
row is deleted.
Note: When you delete or update a row in a parent table
for which a Cascade Delete or Cascade Set Null rule is defined, the
related rows in the child table will be adjusted appropriately, whether
or not explicitly included in the Access Definition or process.
Table Name
Table
Name identifies the table affected by the delete or update
of parent rows.
OK or Cancel
Select OK to
continue saving the Access Definition or executing the process. Select Cancel to
abort the process.