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. |