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

Deleting a Master-Detail Relation

To delete a master-detail relation, select it in the Object Navigator and choose Edit | Clear. The following table shows what happens when you delete a master-detail relation or an object that is part of a relation:

If you delete...

Oracle Forms does this...

A master-detail relation

Deletes all master-detail triggers attached to the relation's master block, and clears the Copy Value from Item property of the foreign-key item(s) in the detail block.

The master or detail block in a relation

Deletes the relation and all associated master-detail triggers, but does not delete the master-detail procedures.

A detail block in a master-with-independent- details relation

Deletes the relation, removes the relevant detail section from the On-Clear-Details trigger and, if present, deletes the On-Populate-Details trigger. Any comments or code that you added in this section also are removed.

The foreign-key item in a detail block, a master-detail trigger, or a master-detail procedure (not recommended)

Nothing. However, a serious side effect is that master-detail block coordination will be disrupted. Though you can hide the foreign-key item in the detail block (by making it a NULL-canvas item), you should not delete it entirely. master-detail triggers and procedures are similarly crucial to ensure master-detail block coordination.

 


Creating objects in the Object Navigator