Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Oracle Tools > Re: How can del...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 3 of 5 Topic 2708 of 2833
Post > Topic >>

Re: How can delete a record in a master-detail relation

by DA Morgan <damorgan@[EMAIL PROTECTED] > Feb 17, 2008 at 12:44 PM

nick048 wrote:
> 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

Delete the detail records first.
-- 
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Wa****ngton
damorgan@[EMAIL PROTECTED]
 (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
 




 5 Posts in Topic:
How can delete a record in a master-detail relation
nick048 <nicosia.gaeta  2008-02-16 00:29:31 
Re: How can delete a record in a master-detail relation
nick048 <nicosia.gaeta  2008-02-16 08:20:45 
Re: How can delete a record in a master-detail relation
DA Morgan <damorgan@[E  2008-02-17 12:44:29 
Re: How can delete a record in a master-detail relation
"paul" <paul  2008-02-24 15:29:49 
Re: How can delete a record in a master-detail relation
yf110@[EMAIL PROTECTED]   2008-02-24 19:59:40 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Tue Dec 2 20:04:53 CST 2008.