dbo.DPR_TIDPRNameSpaceHasDialogTab

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