View Single Post

   
  #1 (permalink)  
Old 04-17-2008, 11:51 PM
Alex du Plessis
 
Posts: n/a
Default Trigger question

I would like to prevent changes being made to a table (b), except when a
trigger fires as a result of changes (insert,update) being made to
another table (a). Should any changes be made to table b by any other
means than the trigger from table a, I would like to trap those changes
(again, could I use a trigger?) and make sure that the original values
in table b stays the same.

Can anybody point me in the right direction please.

Alex du Plessis

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Reply With Quote