Cascading Delete/Update Confirmation Dialog

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.

cascading delete update confirmation display

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.