A script-enabled browser is required for this page to function properly.

Delete Record Behavior Property

Description

(Note: this property was formerly called the Master Deletes property.)

Specifies how the deletion of a record in the master block should affect records in the detail block:

Setting

Description

Non-Isolated

The default setting. Prevents the deletion of a master record when associated detail records exist in the database.

Isolated

Allows the master record to be deleted and does not affect associated detail records in the database.

Cascading

Allows the master record to be deleted and automatically deletes any associated detail records in the detail block's base table at commit time. In a master-detail-detail relation, where relations are nested, only records in the immediate detail block are deleted (deletions do not cascade to multiple levels of a relation chain automatically).

Applies to relation

Set Oracle Forms, programmatically

Refer to Built-in

GET_RELATION_PROPERTY

SET_RELATION_PROPERTY

Default

Non-Isolated

Delete Record Behavior Restrictions


Setting relation properties that affect coordination