(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
Default
Non-Isolated