Home » Developer & Programmer » Forms » master and detail form
master and detail form [message #667017] Tue, 05 December 2017 04:54 Go to next message
Kokew2000
Messages: 11
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
Re: master and detail form [message #667028 is a reply to message #667017] Tue, 05 December 2017 07:55 Go to previous messageGo to next message
joy_division
Messages: 4821
Registered: February 2005
Location: East Coast USA
Senior Member
I don't see any question. I see a bunch of statements.
Punctuation would help.
Re: master and detail form [message #667030 is a reply to message #667028] Tue, 05 December 2017 08:17 Go to previous messageGo to next message
Kokew2000
Messages: 11
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
Re: master and detail form [message #667032 is a reply to message #667030] Tue, 05 December 2017 08:36 Go to previous message
cookiemonster
Messages: 13011
Registered: September 2008
Location: Rainy Manchester
Senior Member
It'd probably help if you posted the code of the pre-delete.
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:
  


Current Time: Sat Feb 17 14:37:44 CST 2018

Total time taken to generate the page: 0.01680 seconds