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

Report message to a moderator

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: 2112
Registered: October 2003
Location: Cincinnati, OH
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

Report message to a moderator

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: 10181
Registered: March 2005
Location: Surges Bay TAS 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

Report message to a moderator

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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Sep 04 12:17:04 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.