Home » Developer & Programmer » Forms » How to change the forms trigger sequence (forms 6i)
How to change the forms trigger sequence [message #442995] Thu, 11 February 2010 22:39 Go to next message
sivaora
Messages: 119
Registered: October 2009
Location: Hyderabad
Senior Member
HI all,
is it possible to change the forms trigger sequence.

for example, i am writing 'when_validate_item' in item level,block level,form level.
First item level will fires and then block level and at last form level.
But i want to fire the trigger first at form level then block level and at last item level.

Re: How to change the forms trigger sequence [message #443004 is a reply to message #442995] Fri, 12 February 2010 00:14 Go to previous messageGo to next message
Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Put "form level trigger code" into "item trigger" and vice versa. Leave the "block level trigger" as is, as it fires in the middle anyway.

I'm not very serious about it; there must be something wrong with the logic, if you need to reverse firing sequence.
Re: How to change the forms trigger sequence [message #443025 is a reply to message #442995] Fri, 12 February 2010 02:24 Go to previous messageGo to next message
sivaora
Messages: 119
Registered: October 2009
Location: Hyderabad
Senior Member
No, this is not the way.
with out modifying the code we have to change the trigger sequence.
i read it somewhere,it is possible by changing the trigger attributes.
but i don't know, how to do it...
Re: How to change the forms trigger sequence [message #443027 is a reply to message #443025] Fri, 12 February 2010 02:43 Go to previous messageGo to next message
Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I said that I wasn't serious.

Did you check "Execution Hierarchy" trigger property? It can be set to Override, Before and After (check what it means in Forms Online Help System).
Re: How to change the forms trigger sequence [message #443147 is a reply to message #443027] Sat, 13 February 2010 00:45 Go to previous messageGo to next message
tamzidulamin
Messages: 132
Registered: October 2009
Location: Dhaka
Senior Member
There are three option of "Execution Hierarchy" of a trigger: i)Override
ii)Before
iii)After

The default trigger Execution Hierarchy is Override as
i) Item_Level trigger,
ii)Block_Level trigger &
iii)Form_Level trigger.

Your can change trigger execution hierarchy of Block Level by Setting Before & Item Level by setting After simultaneously.


Regards,
Tamzidul Amin.
Re: How to change the forms trigger sequence [message #443166 is a reply to message #443147] Sat, 13 February 2010 03:37 Go to previous messageGo to next message
sivaora
Messages: 119
Registered: October 2009
Location: Hyderabad
Senior Member
Thank you very much for your reply.
but where i need to change, can you please give me the navigation.
Re: How to change the forms trigger sequence [message #443212 is a reply to message #443027] Sat, 13 February 2010 12:40 Go to previous message
Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Littlefoot wrote on Fri, 12 February 2010 09:43
Did you check "Execution Hierarchy" trigger property?

You know, Property Palette window (the one that opens when you press F4)?
Previous Topic: check global variable
Next Topic: DBA_ROLE_PRIVS
Goto Forum:
  


Current Time: Fri Sep 20 11:27:27 CDT 2024