dbo.DPR_TUDPRNameSpaceHasDialogTab

1 create   trigger DPR_TUDPRNameSpaceHasDialogTab on DPRNameSpaceHasDialogTable  for Update not for Replication as begin declare @SQLToCheck QBM_YParameterList
2 declare @Debugswitch int = 0 BEGIN TRY if exists (select top 1 1 from inserted) goto start if exists (select top 1 1 from deleted) goto start return start:
3 declare @GenProcID varchar(38) select @GenProcID = dbo.QBM_FGISessionContext('')  if update(IsAdHocSingleMemberShip) or update (whereclause) begin if 
4exists (select top 1 1 from inserted i where i.IsAdHocSingleMemberShip = 0 and i.WhereClause > ' ' ) begin RAISERROR ('#LDS#Whereclauses only allowed for IsAdHocSingleMemberShip = 1.|'
5, 18, 1) WITH NOWAIT end if @Debugswitch > 0 begin print 'update whereclause' select * from inserted end insert into @SQLToCheck(Parameter1, ContentFull
6) select x.XObjectKey, 'select top 1 1 as columnvalue from ' + x.MemberTable + ' as i
7		where(
8		'+ x.WhereClause + '
9		)' from ( select r.ParentTable
10 as ContainerTable , r.childtable as MemberTable, i.WhereClause, i.XObjectKey from QBM_VQBMRelation r join DPRNameSpaceHasDialogTable nht on r.UID_DialogTableChild
11 = nht.UID_DialogTable and r.IsForUpdateXDateSubItem = 1 join QBM_VQBMRelation rm on r.UID_QBMRelationMN = rm.UID_QBMRelation join DialogTable tc on r.ChildTable
12 = tc.TableName and tc.isMNTable = 1 join inserted i on i.UID_DialogTable = r.UID_DialogTableChild where r.IsForUpdateXDateSubItem = 1 and nht.IsAdHocSingleMemberShip
13 = 1 and i.WhereClause > ' ' union select r.ParentTable as ContainerTable , dbo.QBM_FGITableName(rm.UID_DialogTableReference) as MemberTable, i.WhereClause
14, i.XObjectKey from QBM_VQBMRelation r join DPRNameSpaceHasDialogTable nht on r.UID_DialogTableChild = nht.UID_DialogTable and r.IsForUpdateXDateSubItem
15 = 1 join DialogColumn ok on ok.UID_DialogTable = r.UID_DialogTableChild join DialogValidDynamicRef rm on ok.UID_DialogColumn = rm.UID_DialogColumn join
16 DialogTable tc on ok.UID_DialogTable = tc.UID_DialogTable and tc.IsMAllTable = 1 join inserted i on i.UID_DialogTable = r.UID_DialogTableChild where r.IsForUpdateXDateSubItem
17 = 1 and nht.IsAdHocSingleMemberShip = 1 and i.WhereClause > ' ' ) as x if @Debugswitch > 0 begin select c.ContentFull from @SQLToCheck c end exec QBM_PSQLCheckExecutable
18 @SQLToCheck, @RaiseError = 1 declare @DBQueueElements_01 QBM_YDBQueueRaw insert into @DBQueueElements_01 (object, subobject, genprocid) select dbo.QBM_FGITableName
19(x.uid), null, @GenProcID from (select i.UID_DialogTable as UID from DPRNameSpaceHasDialogTable i join deleted d on i.UID_DialogTable = d.UID_DialogTable
20 and i.UID_DPRNameSpace = d.UID_DPRNameSpace where isnull(i.IsAdHocSingleMemberShip ,0) <> isnull(d.IsAdHocSingleMemberShip ,0) or isnull(i.WhereClause
21 , '') <> isnull(d.WhereClause , '') ) as x exec QBM_PDBQueueInsert_Bulk 'DPR-K-TriggerCreateMembership', @DBQueueElements_01 end  END TRY BEGIN CATCH 
22exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH end 
23