dbo.QBM_TUDialogDashBoardDef

1 create   trigger QBM_TUDialogDashBoardDef on DialogDashBoardDef  for Update not for Replication as begin  declare @SQLToCheck QBM_YParameterList
2 declare @ConditionsToCheck QBM_YParameterList BEGIN TRY if exists (select top 1 1 from inserted) goto start if exists (select top 1 1 from deleted) goto
3 start return start: declare @GenProcID varchar(38) select @GenProcID = dbo.QBM_FGISessionContext('')  if update(QueryDefinition100) or update(QueryDefinition
4) or update(AccessWhereClause) begin insert into @SQLToCheck(Parameter1, ContentFull) select c.XObjectKey, c.QueryDefinition100 from inserted c  where 
5c.QueryDefinition100 > ' '  insert into @SQLToCheck(Parameter1, ContentFull) select c.XObjectKey, c.QueryDefinition from inserted c  where c.QueryDefinition
6 > ' '  insert into @SQLToCheck(Parameter1, ContentFull) select c.XObjectKey, 'select top 1 1 as columnvalue from ' + 'DialogDashBoardContent' + '
7		 where (
8		 '
9 + c.AccessWhereClause + '
10		 )' from inserted c  where c.AccessWhereClause > ' ' exec QBM_PSQLCheckExecutable @SQLToCheck, @RaiseError = 1 end if update
11(PreprocessorCondition) begin  insert into @ConditionsToCheck (ContentFull) select i.PreProcessorCondition from inserted i exec QBM_PPrePropCheckSyntax
12 @ConditionsToCheck  declare @DBQueueElements_01 QBM_YDBQueueRaw insert into @DBQueueElements_01 (object, subobject, genprocid) select x.uid, null, @GenProcID
13 from ( select t.uid_DialogDashBoardDef as uid from deleted d join DialogDashBoardDef t on d.uid_DialogDashBoardDef = t.UID_DialogDashBoardDef where isnull
14(d.PreprocessorCondition, N'') <> isnull(t.PreprocessorCondition, N'') ) as x exec QBM_PDBQueueInsert_Bulk 'QBM-K-CommonPrepropDashboardDef', @DBQueueElements_01
15 end if update(IsDeactivatedByPreprocessor) begin declare @DBQueueElements_02 QBM_YDBQueueRaw insert into @DBQueueElements_02 (object, subobject, genprocid
16) select x.uid, null, @GenProcID from ( select t.uid_DialogDashBoardDef as uid from deleted d join DialogDashBoardDef t on d.uid_DialogDashBoardDef = t.UID_DialogDashBoardDef
17 where isnull(d.IsDeactivatedByPreprocessor, 0) <> isnull(t.IsDeactivatedByPreprocessor, 0) ) as x exec QBM_PDBQueueInsert_Bulk 'QBM-K-CommonDashboardDef'
18, @DBQueueElements_02 end if update(QueryDefinition) or update(QueryDefinition100) or update(isInactive) or update(isManual) begin declare @DBQueueElements_03
19 QBM_YDBQueueRaw insert into @DBQueueElements_03 (object, subobject, genprocid) select x.uid, null, @GenProcID from (select uid_DialogDashBoardDef as UID
20 from inserted union select uid_DialogDashBoardDef as UID from deleted ) as x exec QBM_PDBQueueInsert_Bulk 'QBM-K-CommonDashboardDef', @DBQueueElements_03
21 end END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH end 
22