Trigger not firing on update
Reply Quote Delete Edit Favorites Contact I have a master table in a database when updated has to change a location field in other db tables on the same server by a trigger. This update is done from a join linking this table to a change table.
set location = location from changetable where patientmaster.id =changetable.id
This is usually about 3-500 rows
The problem I am having is that the patientmaster table loctation is changing but not the tables that the trigger should have updated.
If I change the update statement to include an id it will work, which will mean going to a cursor for the update. is this correct behavior or a bug/issue? One of the tables being updated is very wide (almost 8000 bytes)