On April 26, 2006 02:35 pm, "Bert" <clemens.bertschler@xxxxxxxxx> wrote: > CREATE TRIGGER trigger_sum > AFTER INSERT OR UPDATE > ON test > FOR EACH ROW > EXECUTE PROCEDURE trigger_test(); > > The inserting and updating is doing well, but its not summing up the a > and b and save it to the c column. So far maybe you can help me second > time. That would need to run BEFORE INSERT OR UPDATE, not AFTER. -- Alan