2 Replies Latest reply: Oct 13, 2012 5:57 AM by sunmat45 RSS

    Update Statement inside a Trigger

    sunmat45
      Hi Guys,

      i have doubts the update trigger.

      Table A: col1,col2,col3,col4 (col1 - PK)

      Table B:col1,col2,col3,col4 (col1 & col2 - created index - PK_C ) col1 & col2 - unique


      now i want one trigger.

      after inserting into both tables. after which If i want change any value on Table A (col2 ) then automatically the Table B (col2) should update what i changed on the Table A (col2)

      Example: Table A
      col1 col2 col3 col4
      123 ABC C POINT


      Table B
      col1 col2 col3 col4
      123 ABC c POINT


      Now i changing value from Table A like col2 as ZXC

      the result should be as

      Example: Table A
      col1 col2 col3 col4
      123 ZXC C POINT


      Table B
      col1 col2 col3 col4
      123 ZXC c POINT