paul (paulq_1998@[EMAIL PROTECTED]
) wrote:
: "nick048" <nicosia.gaetano@[EMAIL PROTECTED]
> wrote in message
:
news:9e0dfb25-3696-4e9a-b466-d26411856dbd@[EMAIL PROTECTED]
> Hi to All,
: >
: > I have created a Form with 3 Blocks:
: > 1) MASTERBLOCK, Table1, PK MASTER_CODE
: > 2) DETAILBLOCK, Table2, KEY = DETAIL_CODE
: > 3) TOOLBAR with button SAVE, ADD, DELETE etc...
: >
: > All Work fine! I can Add, Modify, Save all in the Master and in Detail
: > Block.
: >
: > But If I try to Delete a Master Record, this message is displayed:
: >
: > CANNOT DELETE THE MASTER RECORD IF THERE ARE CORRESPONDING DETAIL
: > RECORDS (NB. I have translated the message from italian language)
: >
: > In the trigger WHEN-BUTTON-PRESSED of DELETE Button I have entered:
: >
: > Delete_Record ;
: >
: > Please can anyone help me in order to delete the master and the detail
: > records?
: >
: > Thank You and Best Regards
: > Gaetano
: Cascade delete
: http://www.techonthenet.com/oracle/foreign_keys/foreign_delete.php
Or Form trigger PRE-DELETE (spelling?), at the Block level
is the hook that allows you to delete them yourself just before Forms runs
the delete command for the master.
|
