Trigger Definition
|
|---|
create trigger TR_CONSTITUENTAPPEALRESPONSE_T2BINSERTUPDATE on dbo.CONSTITUENTAPPEALRESPONSE after insert, update not for replication as begin if dbo.UFN_B2T_CONTEXTISSYNC() = 0 -- force re-sync of the parent row update dbo.B2TROWS set FORCEUPDATE = 1 where BBECID in(select CONSTITUENTAPPEALID from INSERTED) and BBECTABLE = 'CONSTITUENTAPPEAL' end |
