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 might affect a table that is not explicitly referenced in an Access Definition or a process, the Cascading Delete/Update Confirmation dialog is displayed.

Example of the Cascading Delete/Update Confirmation dialog, described as follows.

The Cascading Delete/Update Confirmation dialog lists the names of all tables for which rows might 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. For more information, see General tab in this manual or Product Options in the Installation and Configuration Guide.

In Scope

When selected, the In Scope box indicates that a table is explicitly included in the Access Definition or process. When cleared, it indicates that 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 are adjusted appropriately, whether or not they are explicitly included in the Access Definition or process.

Table Name

Table Name identifies the table that is 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 end the process.



Feedback