dbo.QBM_TUAssembly_DialogParameter
SQL_TRIGGER parent DialogParameter
Created 2025-06-27T18:01:01.643 · modified 2026-04-14T23:23:08.120 · source: live DB sys.objects/sys.sql_expression_dependencies.
Parameters
| Name | Type | Output |
|---|---|---|
| No parameters. | ||
Referenced objects
| Schema | Object | Column/minor | Class |
|---|---|---|---|
| deleted | OBJECT_OR_COLUMN | ||
| dialogparameter | OBJECT_OR_COLUMN | ||
| inserted | OBJECT_OR_COLUMN | ||
| QBM_PDBQueueInsert_Single | OBJECT_OR_COLUMN | ||
| QBM_PSessionErrorAdd | OBJECT_OR_COLUMN | ||
| dbo | QBM_FGISessionContext | OBJECT_OR_COLUMN |
Source excerpt
First extracted SQL definition lines from the exported source. Use the full source page for complete context.
1 create trigger QBM_TUAssembly_DialogParameter on DialogParameter for Update not for Replication as begin declare @GenProcID varchar(38) = dbo.QBM_FGISessionContext 2('') BEGIN TRY if exists (select top 1 1 from inserted) goto start if exists (select top 1 1 from deleted) goto start return start: if update(ValidationScript 3) or update(ValueScript) or update(OnPropertyChangedScript) begin if exists (select top 1 1 from deleted d join dialogparameter p on d.uid_DialogParameter 4 = p.uid_DialogParameter where isnull(d.ValidationScript, N'') <> isnull(p.ValidationScript, N'') or isnull(d.ValueScript, N'') <> isnull(p.ValueScript 5, N'') or isnull(d.OnPropertyChangedScript, N'') <> isnull(p.OnPropertyChangedScript, N'') ) begin exec QBM_PDBQueueInsert_Single 'QBM-K-ScriptAssemblyReset' 6, 'Parameters', '#', @GenProcID end end END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH end 7
Module relation graph
Loading module relation graph…
Source-derived context
Generated from exported SQL module definitions plus read-only sandbox sys.objects/sys.parameters/sys.sql_expression_dependencies metadata. This is factual source evidence, not a semantic guess.
provenance: SQL definition export provenance: sandbox DB metadata modified: 2026-04-14T23:23:08.120
inserts DBQueue tasks uses session context values has TRY/CATCH error handling
Summary: calls QBM_PDBQueueInsert_Single, QBM_PSessionErrorAdd; writes UPDATE not; reads/joins inserted, deleted, dialogparameter
Declared parameters
No declared parameters in sys.parameters for this object, or metadata was not available.
DML targets
UPDATE notCalled routines
Read/join references
SQL dependency metadata
Config/session
Config: None extracted.
Session: None extracted.
DBQueue/tasks
QBM-K-ScriptAssemblyResetTemp tables / referenced variables
Temp: None extracted.
Variables: @GenProcID
Referenced by / reverse dependencies
Generated from live DB metadata, FK rows, and exported SQL dependency/source extraction. This is factual linkage evidence, not inferred behavior.
No reverse dependencies extracted.