OraFAQ Forum: Forms » order of firing triggers

Home » Developer & Programmer » Forms » order of firing triggers

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

order of firing triggers [message #113170]

Thu, 31 March 2005 06:23

vivekdesai
Messages: 4
Registered: March 2005
Location: Ahmedabad

Junior Member

dear all

what is the purpose and order of firing the following triggers

1. on fetch
2. on select

Thanks in Advance

Regards
Vivek

Report message to a moderator

Re: order of firing triggers [message #113173 is a reply to message #113170]

Thu, 31 March 2005 06:35

hsinghalmrt
Messages: 51
Registered: March 2005

Member

the order of firing of these triggers is

Execute Query
After Enter Query

1. Pre-Query Block
2. Pre-Select Block
3. On-Select Block
4. When-Clear-Block Block
5. Post-Select Block
6. On-Fetch Block
7. On-Close Form
8. When-Clear-Block Block

Report message to a moderator

Re: order of firing triggers [message #113262 is a reply to message #113173]

Thu, 31 March 2005 22:30

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Go to Oracle Technology Network, save the Form Builder Reference on your PC, open it before you start work on an Oracle Form, and you will find an answer to your 'what does it do question'. Your 'in which order' question is a bit more difficult. I can't remember the Oracle reference.

If you are working into an Oracle database you should not have to use the 'ON' triggers.

Report message to a moderator

Previous Topic:	How To Show animated GIF or Flash in Oracle form 9i,10g
Next Topic:	how can we connect form builder with MS-Access

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Mar 06 04:00:54 CST 2025