SINGLE SQL TRIGGER for INSERT, UPDATE & DELETE

**sashi** · Nov 19 '06, 04:57 PM

Originally posted by Kushwaha

Hi,

I want to update a field in primary table using a single trigger when I using a foriegn table at the time of inserting a value, deleting a value or modifying that value.

Hi there,

What are the problems that your facing in the event of creating single trigger? Please be clear when asking question.

Kindly refer to below link, hope it helps. Good luck & Take care.

CREATE TRIGGER statement

http://db.apache.org/derby/docs/10.1/ref/rrefsqlj43125.html

CREATE TRIGGER statement, Triggers, creating, defining when they fire, and database events, and the referencing clause, referencing old and new values, statement versus row triggers, the triggered-SQL-statement, order of execution, and recursion

SINGLE SQL TRIGGER for INSERT, UPDATE & DELETE

SINGLE SQL TRIGGER for INSERT, UPDATE & DELETE

Comment