dbo.QBM_PPrePropCheckSyntax
Stored ProcedureSQL_STORED_PROCEDURESandbox DB
Interpretation
- Database routine. Review parameters, called procedures, DBQueue inserts, and QBM_PJobCreate helper calls before assuming side effects.
- DBQueue relation detected. Follow the task procedure and referenced-by list for async processing.
Relations
- Single DBQueue insert -> QBM-K-PrepropGenerateFunction / QBM_ZPrepropGenerateFunction at line 6
- References QBM_PDBQueueInsert_Single
Typed Edges
- queues DBQueue task QBM_ZPrepropGenerateFunction at line 6 Single DBQueue insert -> QBM-K-PrepropGenerateFunction / QBM_ZPrepropGenerateFunction at line 6
- references source dbo.QBM_FGISessionContext source text reference
- references source dbo.QBM_FGISessionErrorRethrow source text reference
- references source dbo.QBM_PDBQueueInsert_Single source text reference
- references source dbo.QBM_PPrePropCheckExpression source text reference
- references source dbo.QBM_PSessionErrorAdd source text reference
- queues DBQueue task QBM-K-PrepropGenerateFunction -> QBM_ZPrepropGenerateFunction QBM_PDBQueueInsert_Single 'QBM-K-PrepropGenerateFunction', '', '', @GenProcID end END TRY BEGIN CATCH declare @Message nvarchar(4000) = concat('Invalid Syntax in preprocessor condition "' , @PreProcessorCondition , '"' ) exec QBM_PSessionE…
References
- dbo.QBM_FGISessionContext
- dbo.QBM_FGISessionErrorRethrow
- dbo.QBM_PDBQueueInsert_Single
- dbo.QBM_PPrePropCheckExpression
- dbo.QBM_PSessionErrorAdd
Referenced By
- dbo.ATT_TIAttestationObject
- dbo.ATT_TIAttestationWizardParm
- dbo.ATT_TUAttestationObject
- dbo.ATT_TUAttestationWizardParm
- dbo.QBM_TIDialogColumn
- dbo.QBM_TIDialogCustomizer
- dbo.QBM_TIDialogDashBoardDef
- dbo.QBM_TIDialogGroup
- dbo.QBM_TIDialogObject
- dbo.QBM_TIDialogReport
- dbo.QBM_TIDialogReportQueryModule
- dbo.QBM_TIDialogSheet
- dbo.QBM_TIDialogTable
- dbo.QBM_TIJob
- dbo.QBM_TIJobChain
- dbo.QBM_TIQBMTree
- dbo.QBM_TIQBMTreeResult
- dbo.QBM_TUDialogColumn
- dbo.QBM_TUDialogCustomizer
- dbo.QBM_TUDialogDashBoardDef
- dbo.QBM_TUDialogGroup
- dbo.QBM_TUDialogObject
- dbo.QBM_TUDialogReport
- dbo.QBM_TUDialogReportQueryModule
- dbo.QBM_TUDialogSheet
- dbo.QBM_TUDialogTable
- dbo.QBM_TUJob
- dbo.QBM_TUJobChain
- dbo.QBM_TUQBMTree
- dbo.QBM_TUQBMTreeResult
- dbo.RPS_TIRPSReport
- dbo.RPS_TURPSReport
Complete Source
1CREATE PROCEDURE QBM_PPrePropCheckSyntax(2 @Conditions QBM_YParameterList READONLY3)4AS5BEGIN6 DECLARE @PreProcessorCondition nvarchar(max)7 DECLARE @tabelle QBM_YCursorBuffer8 DECLARE @ElementCount int9 DECLARE @ElementIndex int10 DECLARE @zeiger varchar(38)11 DECLARE @GenProcID varchar(38)12 SET XACT_ABORT OFF13 BEGIN TRY14 SELECT @GenProcID = dbo.QBM_FGISessionContext('')15 INSERT INTO @tabelle(UID1,16 ContentFull)17 SELECT18 newid(),19 x.ContentFull20 FROM @Conditions x21 WHERE22 x.ContentFull > ' '23 SELECT @ElementCount = @@rowcount24 SELECT @ElementIndex = 125 WHILE @ElementIndex <= @ElementCount26 BEGIN27 SELECT28 TOP 1 @zeiger = bu.UID1,29 @PreProcessorCondition = bu.ContentFull30 FROM @tabelle bu31 WHERE32 bu.ElementIndex = @ElementIndex33 EXEC QBM_PPrePropCheckExpression @PreProcessorCondition,34 ''35 SELECT @ElementIndex += 136 END37 IF(38 SELECT count(*)39 FROM @Conditions x40 WHERE41 x.ContentFull > ' ') > 042 BEGIN43 EXEC QBM_PDBQueueInsert_Single 'QBM-K-PrepropGenerateFunction',44 '',45 '',46 @GenProcID47 END48 END TRY49 BEGIN CATCH50 DECLARE @Message nvarchar(4000) = CONCAT('Invalid Syntax in preprocessor condition "',51 @PreProcessorCondition,52 '"')53 EXEC QBM_PSessionErrorAdd DEFAULT,54 @Message55 DECLARE @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow()56 RAISERROR(@Rethrow,57 18,58 1)59 WITH NOWAIT60 END CATCH61 ende:62 RETURN63ENDOpen raw exported source
1 create procedure QBM_PPrePropCheckSyntax (@Conditions QBM_YParameterList readonly ) as begin declare @PreProcessorCondition nvarchar2(max) declare @tabelle QBM_YCursorBuffer declare @ElementCount int declare @ElementIndex int declare @zeiger varchar(38) declare @GenProcID varchar(38)3 SET XACT_ABORT OFF BEGIN TRY select @GenProcID = dbo.QBM_FGISessionContext('') insert into @tabelle (UID1, ContentFull) select newid(), x.ContentFull 4from @Conditions x where x.ContentFull > ' ' select @ElementCount = @@rowcount select @ElementIndex = 1 while @ElementIndex <= @ElementCount begin select5 top 1 @zeiger = bu.UID1 , @PreProcessorCondition = bu.ContentFull from @tabelle bu where bu.ElementIndex = @ElementIndex exec QBM_PPrePropCheckExpression6 @PreProcessorCondition, '' select @ElementIndex += 1 end if (select count(*) from @Conditions x where x.ContentFull > ' ' ) > 0 begin exec QBM_PDBQueueInsert_Single7 'QBM-K-PrepropGenerateFunction', '', '', @GenProcID end END TRY BEGIN CATCH declare @Message nvarchar(4000) = concat('Invalid Syntax in preprocessor condition "'8 , @PreProcessorCondition , '"' ) exec QBM_PSessionErrorAdd default, @Message declare @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow() RAISERROR9 (@Rethrow, 18, 1) WITH NOWAIT END CATCH ende: return end 10