What are the types of  TRIGGERS ?

 1. Navigational Triggers.   2. Transaction Triggers.

Showing Answers 1 - 6 of 6 Answers

mukts

  • Mar 31st, 2006
 

Block Processing

Interface

  Was this answer useful?  Yes

Nitin Gaur

  • Jul 2nd, 2007
 

ThereĀ  are two types of trigger. First Row Level and Second Statement Level.

Further trigger is divided based on timingĀ as BEFORE and AFTER.

Moreover, based on events trigger is divided as INSERT, UPDATE and DELETE.

So, total number of triggers are:

(3 (INSERT, UPDATE, DELETE) * 2 (BEFORE, AFTER) * 2 (ROW LEVEL, STATEMENT LEVEL)) + 1 (INSTEAD OF ) = 13

Basically, above text are about database transaction trigger.

kirangsv

  • Jan 8th, 2008
 

If you are talking about the triggers in forms-6i. There are 2 types of triggers namely
FORM LEVEL TRIGGER, BLOCK LEVEL TRIGGER
FORM LEVEL TRIGGER fires to that particular form only
BLOCK LEVEL TRIGGER fires to the entire block ie datablock

  Was this answer useful?  Yes

actually there r 3 levels of triggers
1)formlevel  2)block level  3) item level

and types of triggers r
1 activex triggers
2 block processing triggers
3 interface event triggers
4 key triggers
5master detail triggers
6 message handling triggers
7 mouse event triggers
8navigation triggers
9 on triggers
post triggers
pre triggers
query time triggers
stored  procedure triggers
transactional triggers
validation triggers
when triggers

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Answer Question

Click here to Login / Register your free account


 
Send   Reset

 

Related Answered Questions

 

Related Open Questions