Re: Adding two different Event triggers for the same table

[sushaanth srirangapathi]

It's that column "a" is a unique name formed from the concatenating entries in columns "B" and "c". It's assumed that Concatenating "B" and "c" will give a unique key. So the user will add only values in "b" and "c" and the trigger will create value for Column "a" using "before insert" trigger and insert it into table. There is also a use case in which column "B" or column "c" will be changed. So i need also have a "before update" trigger which will calculate the column "a" before updating.
guys help me out...need to know it in urgent



Edited 1 time(s). Last edit at 04/17/2013 02:44AM by sushaanth srirangapathi.