Back to OIM Explorer

dbo.QBM_TIDialogObject

Database TriggerSQL_TRIGGERSandbox DB

Database Trigger on DialogObject. Bulk DBQueue insert -> QBM-K-CommonPrepropObject / QBM_ZPrePropObject at line 10; References QBM_PDBQueueInsert_Bulk; Trigger parent table: DialogObject

Source: sandbox-db sys.sql_modules

Source size: 1.207 characters

Interpretation

  • Database trigger. Treat parent table and enqueue/object-layer calls as the main relation points.
  • DBQueue relation detected. Follow the task procedure and referenced-by list for async processing.

Relations

  • Bulk DBQueue insert -> QBM-K-CommonPrepropObject / QBM_ZPrePropObject at line 10
  • References QBM_PDBQueueInsert_Bulk
  • Trigger parent table: DialogObject

Typed Edges

  • queues DBQueue task QBM_ZPrePropObject at line 10 Bulk DBQueue insert -> QBM-K-CommonPrepropObject / QBM_ZPrePropObject at line 10
  • trigger on table DialogObject Trigger parent table: DialogObject
  • references source dbo.QBM_FGISessionContext source text reference
  • references source dbo.QBM_PDBQueueInsert_Bulk source text reference
  • references source dbo.QBM_PPrePropCheckSyntax source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference
  • references source dbo.QBM_PSQLCheckExecutable source text reference

References

Referenced By

Complete Source

SQL56 lines
1CREATE trigger QBM_TIDialogObject2  ON DialogObject FOR3INSERT NOT FOR Replication4AS5BEGIN6  DECLARE @SQLToCheck QBM_YParameterList7  DECLARE @ConditionsToCheck QBM_YParameterList8  BEGIN TRY9    IF EXISTS(10      SELECT TOP 1 111      FROM inserted)12    GOTO start13    RETURN start:14    DECLARE @GenProcID varchar(38)15    SELECT @GenProcID = dbo.QBM_FGISessionContext('')16    INSERT INTO @ConditionsToCheck(ContentFull)17    SELECT i.PreProcessorCondition18    FROM inserted i19    EXEC QBM_PPrePropCheckSyntax @ConditionsToCheck20    INSERT INTO @SQLToCheck(Parameter1,21    ContentFull)22    SELECT23      c.XObjectKey,24      'select top 1 1 as columnvalue from ' + t.TableName + '25		 where (26		 ' + c.WhereClause + '27		 )'28    FROM inserted c29    JOIN DialogTable t30      ON c.UID_DialogTable = t.UID_DialogTable31    WHERE32      c.WhereClause > ' '33    EXEC QBM_PSQLCheckExecutable @SQLToCheck,34      @RaiseError = 135    DECLARE @DBQueueElements_01 QBM_YDBQueueRaw36    INSERT INTO @DBQueueElements_01(object,37    subobject,38    genprocid)39    SELECT40      x.uid,41      NULL,42      @GenProcID43    FROM(44    SELECT uid_dialogObject AS UID45    FROM inserted) AS x46    EXEC QBM_PDBQueueInsert_Bulk 'QBM-K-CommonPrepropObject',47      @DBQueueElements_0148  END TRY49  BEGIN CATCH50    EXEC QBM_PSessionErrorAdd DEFAULT51    RAISERROR('',52    18,53    1)54      WITH NOWAIT55  END CATCH56END
Open raw exported source
SQL ยท Raw12 lines
1  create   trigger QBM_TIDialogObject on DialogObject  for Insert not for Replication as begin  declare @SQLToCheck QBM_YParameterList declare @ConditionsToCheck2 QBM_YParameterList BEGIN TRY if exists (select top 1 1 from inserted) goto start return start: declare @GenProcID varchar(38) select @GenProcID = dbo.QBM_FGISessionContext3('')  insert into @ConditionsToCheck (ContentFull) select i.PreProcessorCondition from inserted i exec QBM_PPrePropCheckSyntax @ConditionsToCheck   insert4 into @SQLToCheck(Parameter1, ContentFull) select c.XObjectKey, 'select top 1 1 as columnvalue from ' + t.TableName + '5		 where (6		 ' + c.WhereClause7 + '8		 )' from inserted c  join DialogTable t on c.UID_DialogTable = t.UID_DialogTable where c.WhereClause > ' ' exec QBM_PSQLCheckExecutable @SQLToCheck9, @RaiseError = 1  declare @DBQueueElements_01 QBM_YDBQueueRaw insert into @DBQueueElements_01 (object, subobject, genprocid) select x.uid, null, @GenProcID10 from (select uid_dialogObject as UID from inserted ) as x exec QBM_PDBQueueInsert_Bulk 'QBM-K-CommonPrepropObject', @DBQueueElements_01  END TRY BEGIN11 CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH end 12