Back to OIM Explorer

dbo.QBM_TIDialogParameter

Database TriggerSQL_TRIGGERSandbox DB

Database Trigger on DialogParameter. Trigger parent table: DialogParameter

Source: sandbox-db sys.sql_modules

Source size: 826 characters

Interpretation

  • Database trigger. Treat parent table and enqueue/object-layer calls as the main relation points.

Relations

  • Trigger parent table: DialogParameter

Typed Edges

  • trigger on table DialogParameter Trigger parent table: DialogParameter
  • references source dbo.QBM_FGISessionContext source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference
  • references source dbo.QBM_PSQLCheckExecutable source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL40 lines
1CREATE trigger QBM_TIDialogParameter2  ON DialogParameter FOR3INSERT NOT FOR Replication4AS5BEGIN6  DECLARE @SQLToCheck QBM_YParameterList7  DECLARE @GenProcID varchar(38)8  SELECT @GenProcID = dbo.QBM_FGISessionContext('')9  BEGIN TRY10    IF EXISTS(11      SELECT TOP 1 112      FROM inserted)13    GOTO start14    RETURN start:15    INSERT INTO @SQLToCheck(Parameter1,16    ContentFull)17    SELECT18      c.XObjectKey,19      'select top 1 1 as columnvalue from ' + t.TableName + '20		 where (21		 ' + c.QueryWhereClause + '22		 )'23    FROM inserted c24    JOIN DialogColumn cc25      ON c.UID_DialogColumnQuery = cc.UID_DialogColumn26    JOIN DialogTable t27      ON t.UID_DialogTable = cc.UID_DialogTable28    WHERE29      c.QueryWhereClause > ' '30    EXEC QBM_PSQLCheckExecutable @SQLToCheck,31      @RaiseError = 132  END TRY33  BEGIN CATCH34    EXEC QBM_PSessionErrorAdd DEFAULT35    RAISERROR('',36    18,37    1)38      WITH NOWAIT39  END CATCH40END
Open raw exported source
SQL ยท Raw10 lines
1  create   trigger QBM_TIDialogParameter on DialogParameter  for Insert not for Replication as begin  declare @SQLToCheck QBM_YParameterList declare2 @GenProcID varchar(38) select @GenProcID = dbo.QBM_FGISessionContext('') BEGIN TRY if exists (select top 1 1 from inserted) goto start return start:  3insert into @SQLToCheck(Parameter1, ContentFull) select c.XObjectKey, 'select top 1 1 as columnvalue from ' + t.TableName + '4		 where (5		 ' + c.QueryWhereClause6 + '7		 )' from inserted c  join DialogColumn cc on c.UID_DialogColumnQuery = cc.UID_DialogColumn join DialogTable t on t.UID_DialogTable = cc.UID_DialogTable8 where c.QueryWhereClause > ' ' exec QBM_PSQLCheckExecutable @SQLToCheck, @RaiseError = 1 END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR9 ('', 18, 1) WITH NOWAIT END CATCH end 10