dbo.QBM_TUAssembly_DialogColumn

1 create   trigger QBM_TUAssembly_DialogColumn on DialogColumn  for Update not for Replication as begin declare @GenProcID varchar(38) = dbo.QBM_FGISessionContext
2('') declare @XUser nvarchar(64) = object_name(@@procid) declare @Xdate datetime = getutcdate() BEGIN TRY if exists (select top 1 1 from inserted) goto
3 start if exists (select top 1 1 from deleted) goto start return start: if update(FormatScript) or update(IsDeactivatedByPreProcessor) or update(Template
4) or update(CanSeeScript) or update(CanEditScript) begin if exists (select top 1 1 from deleted d join DialogColumn c on d.UID_DialogColumn = c.UID_DialogColumn
5 where ( ISNULL(d.FormatScript, '') <> ISNULL(c.FormatScript, '') or d.IsDeactivatedByPreProcessor <> c.IsDeactivatedByPreProcessor or ISNULL(d.Template
6, '') <> ISNULL(c.Template, '') or ISNULL(d.CanSeeScript, '') <> ISNULL(c.CanSeeScript, '') or ISNULL(d.CanEditScript, '') <> ISNULL(c.CanEditScript, ''
7) ) ) begin  exec QBM_PDBQueueInsert_Single 'QBM-K-ScriptAssemblyReset', 'Tmpl', '#', @GenProcID  end end  if update(IsOverwritingTemplate) or update(Template
8) or update(Format) or update(FormatScript) begin update dialogcolumn set IsTemplateChanged = 1 , XDateUpdated = @Xdate , XUserUpdated = @XUser where uid_dialogcolumn
9 in (select uid_dialogcolumn from inserted) and isnull(IsTemplateChanged,0) = 0 end if update(Columnname) or update(DataType) or update(CustomComment) 
10or update(Commentary) or update(IsDeactivatedByPreProcessor) begin exec QBM_PDBQueueInsert_Single 'QBM-K-ScriptAssemblyReset', 'TypedWrappers', '#', @GenProcID
11 end   if update(UID_DialogTable) or update(ColumnName) or update(uid_basecolumn)  or update(UID_DialogColumnUnionView) or update(IsDeactivatedByPreprocessor
12)  or update(IsNoAutoExtendPermissions) begin  declare @DBQueueElements_01 QBM_YDBQueueRaw insert into @DBQueueElements_01 (object, subobject, genprocid
13) select x.uid, null, @GenProcID from (select i.UID_DialogTable as UID from inserted i union select d.UID_DialogTable as UID from deleted d union select
14 t.UID_DialogTableBase from dialogtable t join inserted i on i.UID_DialogTable = t.UID_DialogTable where t.UID_DialogTableBase > ' ' union select t.UID_DialogTableBase
15 from dialogtable t join deleted d on d.UID_DialogTable = t.UID_DialogTable where t.UID_DialogTableBase > ' '  union select t.UID_DialogTableUnion from
16 dialogtable t join deleted d on d.UID_DialogTable = t.UID_DialogTable where t.UID_DialogTableUnion > ' ' union select t.UID_DialogTableUnion from dialogtable
17 t join inserted d on d.UID_DialogTable = t.UID_DialogTable where t.UID_DialogTableUnion > ' ' ) as x exec QBM_PDBQueueInsert_Bulk 'QBM-K-CommonRebuildView'
18, @DBQueueElements_01 end  if update(datatype) or update(isPkmember) or update(isAlternatePkmember) or update(IsToWatch)  or update(IsToWatchDelete) or
19 update(IsCustomConfigurable) or update(IsDeactivatedByPreProcessor)  or update(SplittedLookupSupport) begin declare @DBQueueElements_02 QBM_YDBQueueRaw
20 insert into @DBQueueElements_02 (object, subobject, genprocid) select dbo.QBM_FGITableName(x.uid), null, @GenProcID from (select i.UID_DialogTable as 
21UID from Dialogcolumn i join deleted d on i.UID_DialogColumn = d.UID_DialogColumn where isnull(i.datatype,0) <> isnull(d.datatype,0) or isnull(i.isPkmember
22,0) <> isnull(d.isPkmember,0) or isnull(i.isAlternatePkmember,0) <> isnull(d.isAlternatePkmember,0) or isnull(i.IsToWatch,0) <> isnull(d.IsToWatch,0)  
23or isnull(i.IsToWatchDelete,0) <> isnull(d.IsToWatchDelete,0) or isnull(i.IsCustomConfigurable,0) <> isnull(d.IsCustomConfigurable,0) or isnull(i.IsDeactivatedByPreProcessor
24,0) <> isnull(d.IsDeactivatedByPreProcessor,0) or isnull(i.SplittedLookupSupport, '') <> isnull(d.SplittedLookupSupport, '') union select t.UID_DialogTableBase
25 from dialogtable t join inserted i on i.UID_DialogTable = t.UID_DialogTable where t.UID_DialogTableBase > ' ' union select t.UID_DialogTableBase from 
26dialogtable t join deleted d on d.UID_DialogTable = t.UID_DialogTable where t.UID_DialogTableBase > ' ' union  select t.UID_DialogTable from dialogtable
27 t join inserted c on c.UID_DialogTable = t.UID_DialogTableUnion  ) as x exec QBM_PDBQueueInsert_Bulk 'QBM-K-CommonMakeWatchtrigger', @DBQueueElements_02
28 end  END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH ende: return end 
29