5 Replies Latest reply on Jul 3, 2004 3:41 AM by Alexey Loubyansky

    UPDATE after INSERT in CMR

    mkyaj Newbie

      Hi,

      To put my problem with an example i have a CMR USER(1) -ADDRESS(m).
      When i create an User, it will create the corresponding Addresses(say 3 different addresses for this instance) also.
      It is calling
      INSERT INTO ADDRESS(field1,field2,USER_FK) VALUES(?,?,?).
      INSERT INTO ADDRESS(field1,field2,USER_FK) VALUES(?,?,?).
      INSERT INTO ADDRESS(field1,field2,USER_FK) VALUES(?,?,?).

      and after that it is again calling
      UPDATE ADDRESS set USER_FK=? WHERE ID=?
      UPDATE ADDRESS set USER_FK=? WHERE ID=?
      UPDATE ADDRESS set USER_FK=? WHERE ID=?

      How to stop updating immediately after creation?

      Murali.