Trigger to update field in new record based on second field in new record.

Giganews Newsgroups
Subject: Trigger to update field in new record based on second field in new record.
Posted by:  Richard (richard.mo…@gmail.com)
Date: Sat, 23 Oct 2010

Here is a SQL statement that I am currently running:

update timecard set tudef1='JP0' where tudef5='JP' and tmatter in
(select mmatter from matter where mloc='30')

I would like this update to happen when a new record is inserted in
the timecard table.  How can I set up a trigger to do this.

Thanks in advance

Rich

Replies