HOw to apply priority on database triggers [message #262782] |
Tue, 28 August 2007 05:02  |
shrek
Messages: 1 Registered: August 2007
|
Junior Member |
|
|
Dear All,
There are 3 tables, A B and C
2 after insert triggers on table A.
when there is record insert in Table A
then trigger 1 fires to insert data into B and trigger 2 fires to insert data in C.
Now C has a FK to B so before inserting into C , table B should be inserted first.
now from the above case, how we can give the priority to the two triggers so that trigger 1 fires first and then trigger 2.
as we are new to the trigger concept we are not able to find a right solution.
thanks in advance
Rgds,
shrek
|
|
|
|
|
|
|