dbo.QBM_TUDialogObject

1 create   trigger QBM_TUDialogObject on DialogObject  for Update not for Replication as begin  declare @SQLToCheck QBM_YParameterList declare @ConditionsToCheck
2 QBM_YParameterList BEGIN TRY if exists (select top 1 1 from inserted) goto start if exists (select top 1 1 from deleted) goto start return start: declare
3 @GenProcID varchar(38) select @GenProcID = dbo.QBM_FGISessionContext('')  if update(WhereClause) begin insert into @SQLToCheck(Parameter1, ContentFull
4) select c.XObjectKey, 'select top 1 1 as columnvalue from ' + t.TableName + '
5		 where (
6		 ' + c.WhereClause + '
7		 )' from inserted c  join DialogTable
8 t on c.UID_DialogTable = t.UID_DialogTable where c.WhereClause > ' ' exec QBM_PSQLCheckExecutable @SQLToCheck, @RaiseError = 1 end  if update(PreprocessorCondition
9) begin  insert into @ConditionsToCheck (ContentFull) select i.PreProcessorCondition from inserted i exec QBM_PPrePropCheckSyntax @ConditionsToCheck  declare
10 @DBQueueElements_01 QBM_YDBQueueRaw insert into @DBQueueElements_01 (object, subobject, genprocid) select x.uid, null, @GenProcID from (select i.uid_dialogObject
11 as UID from DialogObject i join deleted d on i.uid_dialogObject = d.uid_dialogObject where isnull(i.PreprocessorCondition,N'') <> isnull(d.PreprocessorCondition
12,N'') ) as x exec QBM_PDBQueueInsert_Bulk 'QBM-K-CommonPrepropObject', @DBQueueElements_01 end END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR
13 ('', 18, 1) WITH NOWAIT END CATCH end 
14