OraFAQ Forum: Forms » master and detail form

Home » Developer & Programmer » Forms » master and detail form

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

master and detail form [message #667017]

Tue, 05 December 2017 04:54

Kokew2000
Messages: 12
Registered: December 2017

Junior Member

hello guys
i have master and detail form with cascading relationship
and i make trigger before delete on detail form and working without problem
but when delete from master block ! delete from master and detail block without check trigger in detail form
also when i put trigger in on-check-delete master
it working if condetion true with first column in detail form

Report message to a moderator

Re: master and detail form [message #667028 is a reply to message #667017]

Tue, 05 December 2017 07:55

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

I don't see any question. I see a bunch of statements.
Punctuation would help.

Report message to a moderator

Re: master and detail form [message #667030 is a reply to message #667028]

Tue, 05 December 2017 08:17

Kokew2000
Messages: 12
Registered: December 2017

Junior Member

i will try to explain for you
i have form master and detail block okay
and a relationship is cascading okay
and i write trigger pre-delete on detail block and it working without problem okay
but when i delete from master block it delete from master and detail block cause relation is cascading
so i want before delete from master block check trigger in detail form and raise to delete until check pre-delete in detail form
i wish if i can explain my problem
and thank you for your answer

Report message to a moderator

Re: master and detail form [message #667032 is a reply to message #667030]

Tue, 05 December 2017 08:36

cookiemonster
Messages: 13920
Registered: September 2008
Location: Rainy Manchester

Senior Member

It'd probably help if you posted the code of the pre-delete.

Report message to a moderator

Previous Topic:	FRM-40102 record must be entered or deleted---------error
Next Topic:	Oracle Form Builder 11g hangs on connect to database express 11g

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 11:33:45 CDT 2024