Home » Developer & Programmer » Forms » triggers fired in certain situations (oracle forms 6i,windows xp)
triggers fired in certain situations [message #290641] Mon, 31 December 2007 00:22 Go to next message
dmerin
Messages: 30
Registered: December 2007
Member
Hi,

Can anyone pls tell me what are the triggers fired in the foll cases

1)on navigating from one form to next

2)on navigating from one block to next

3)on navigating from one record to next

Please list out all the triggers
Re: triggers fired in certain situations [message #290672 is a reply to message #290641] Mon, 31 December 2007 01:35 Go to previous messageGo to next message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
For 1, 2 and 3
PRE-<FORM/BLOCK/RECORD>
WHEN-VALIDATE-RECORD -- only for 3
WHEN-NEW-<FORM/BLOCK/RECORD>-INSTANCE
POST-<FORM/BLOCK/RECORD>

Thanks,
Vamsi
Re: triggers fired in certain situations [message #291810 is a reply to message #290672] Sun, 06 January 2008 23:55 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Actually, the 'post' triggers fire in order from the lower to the higher level, that is, POST-<RECORD/BLOCK/FORM>

David
Re: triggers fired in certain situations [message #291811 is a reply to message #291810] Sun, 06 January 2008 23:57 Go to previous message
dmerin
Messages: 30
Registered: December 2007
Member
hi,

Thanks alot
u are right
Previous Topic: Hot To check Application Directory
Next Topic: error in deleting record due to foreign key violation
Goto Forum:
  


Current Time: Thu Dec 08 10:09:28 CST 2016

Total time taken to generate the page: 0.09943 seconds