Re: INSERT, UPDATE

From: Nick Butcher <nickb_at_btinternet.com>
Date: Thu, 03 Dec 1998 16:25:22 +0000
Message-ID: <3666BB72.2B35@btinternet.com>

Why not use a database trigger and save yourself the trouble.

CREATE OR REPLACE TRIGGER tab_2_trigger AFTER INSERT OR UPDATE ON tab2
FOR EACH ROW
BEGIN
  IF INSERTING THEN
    INSERT INTO tab1
     (ch1, ch2, ch3, ch4)
    VALUES
     (:new.ch1, :new.ch2, :new.ch3, :new.ch4);   ELSIF UPDATING THEN
    UPDATE tab1

       SET ch1 = :new.ch1,
           ch2 = :new.ch2,
           ch3 = :new.ch3,
           ch4 = :new.ch4
     WHERE ch1 = :old.ch1
       AND ch2 = :old.ch2
       AND ch3 = :old.ch3
       AND ch4 = :old.ch4;

END IF;
END;
/

Should do the trick

Regards

Nick Received on Thu Dec 03 1998 - 10:25:22 CST