urgent plz help me [message #375147] |
Tue, 31 July 2001 08:02 |
Amit
Messages: 166 Registered: February 1999
|
Senior Member |
|
|
hai!
I created 7 child relations for a single relation. I want to delete one row from the parent table. I created a trigger which deletes the corresponding rows from the child tables. I dont have a chance of cascade delete. plz help me by suggesting the trigger in the right way. it is giving the message constraint voilated. child record found
any help is appreciated
thanks in advance
amit
|
|
|
Re: urgent plz help me [message #375148 is a reply to message #375147] |
Tue, 31 July 2001 09:47 |
Senthil
Messages: 68 Registered: December 1999
|
Member |
|
|
Create a "before delete" trigger on a parent table...the trigger code has to delete all related rows from the child table...finaly...delete a row from the master table.
|
|
|
|