Home > Class Reference > ENSLIB namespace > %Dictionary.CompiledTrigger

%Dictionary.CompiledTrigger

persistent class %Dictionary.CompiledTrigger extends %Library.Persistent, %Dictionary.CompiledTriggerQuery

SQL Table Name: %Dictionary.CompiledTrigger

Property Inventory

Method Inventory

Parameters

parameter SQLENABLED = 1;

Properties

property Code as %RawString;
The code that is executed when the trigger is fired.
Property methods: CodeGet(), CodeIsDefined(), CodeIsValid(), CodeModeGet(), CodeModeIsDefined(), CodeModeIsValid(), CodeModeReset(), CodeModeSet(), CodeReset(), CodeSet()
property CodeMode as %RawString;
Specifies how a given method is implemented: lines of code to be compiled, or a method that will generate the resulting method or object.
Property methods: CodeModeGet(), CodeModeIsDefined(), CodeModeIsValid(), CodeModeReset(), CodeModeSet()
property CompilerGenerated as %Boolean;
CompilerGenerated
Property methods: CompilerGeneratedDisplayToLogical(), CompilerGeneratedGet(), CompilerGeneratedIsValid(), CompilerGeneratedLogicalToDisplay(), CompilerGeneratedNormalize(), CompilerGeneratedSet()
property Deprecated as %Boolean;
True if this trigger is deprecated.
Property methods: DeprecatedDisplayToLogical(), DeprecatedGet(), DeprecatedIsDefined(), DeprecatedIsValid(), DeprecatedLogicalToDisplay(), DeprecatedNormalize(), DeprecatedReset(), DeprecatedSet()
property Description as %RawString;
Specifies a description of the SQL trigger.
Property methods: DescriptionGet(), DescriptionIsDefined(), DescriptionIsValid(), DescriptionReset(), DescriptionSet()
property Event as %RawString;
Specifies the SQL event that will fire the trigger.
Property methods: EventGet(), EventIsDefined(), EventIsValid(), EventReset(), EventSet()
property Final as %Boolean;
Specifies that subclasses cannot override the definition of the SQL trigger.
Property methods: FinalDisplayToLogical(), FinalGet(), FinalIsDefined(), FinalIsValid(), FinalLogicalToDisplay(), FinalNormalize(), FinalReset(), FinalSet()
property Foreach as %RawString;
Indicates if the trigger will be invoked for each row, for rows and objects, or for each statement
Property methods: ForeachGet(), ForeachIsDefined(), ForeachIsValid(), ForeachReset(), ForeachSet()
property Id as %Integer;
Id
Property methods: IdDisplayToLogical(), IdGet(), IdIsValid(), IdLogicalToDisplay(), IdNormalize(), IdSet()
property InheritedId as %Boolean;
InheritedId
Property methods: InheritedIdDisplayToLogical(), InheritedIdGet(), InheritedIdIsValid(), InheritedIdLogicalToDisplay(), InheritedIdNormalize(), InheritedIdSet()
property Internal as %Boolean;
If true, then do not display this item in automatic documentation.
Property methods: InternalDisplayToLogical(), InternalGet(), InternalIsDefined(), InternalIsValid(), InternalLogicalToDisplay(), InternalNormalize(), InternalReset(), InternalSet()
property KeywordError as %Boolean;
KeywordError
Property methods: KeywordErrorDisplayToLogical(), KeywordErrorGet(), KeywordErrorIsValid(), KeywordErrorLogicalToDisplay(), KeywordErrorNormalize(), KeywordErrorSet()
property KeywordModified as %Boolean;
KeywordModified
Property methods: KeywordModifiedDisplayToLogical(), KeywordModifiedGet(), KeywordModifiedIsValid(), KeywordModifiedLogicalToDisplay(), KeywordModifiedNormalize(), KeywordModifiedSet()
property Language as %RawString [ SqlFieldName = _Language ];
The language used to implement this trigger.
Property methods: LanguageGet(), LanguageIsDefined(), LanguageIsValid(), LanguageReset(), LanguageSet()
property Name as %Dictionary.Identifier [ Required ];
The name of the SQL trigger.
Property methods: NameGet(), NameIsDefined(), NameIsValid(), NameReset(), NameSet()
property NewTable as %RawString;
The name of the SQL table that holds old values for the trigger.
Property methods: NewTableGet(), NewTableIsDefined(), NewTableIsValid(), NewTableReset(), NewTableSet()
property NotInheritable as %Boolean;
NotInheritable
Property methods: NotInheritableDisplayToLogical(), NotInheritableGet(), NotInheritableIsValid(), NotInheritableLogicalToDisplay(), NotInheritableNormalize(), NotInheritableSet()
property OldTable as %RawString;
The name of the SQL table that holds old values for the trigger.
Property methods: OldTableGet(), OldTableIsDefined(), OldTableIsValid(), OldTableReset(), OldTableSet()
property Order as %Integer;
In the case of multiple triggers for the same EVENT and TIME, specifies the order in which the triggers should be fired.
Property methods: OrderDisplayToLogical(), OrderGet(), OrderIsDefined(), OrderIsValid(), OrderLogicalToDisplay(), OrderNormalize(), OrderReset(), OrderSet()
property Origin as %RawString;
Origin
Property methods: OriginGet(), OriginIsValid(), OriginSet()
property SequenceNumber as %Integer;
SequenceNumber
Property methods: SequenceNumberDisplayToLogical(), SequenceNumberGet(), SequenceNumberIsDefined(), SequenceNumberIsValid(), SequenceNumberLogicalToDisplay(), SequenceNumberNormalize(), SequenceNumberReset(), SequenceNumberSet()
property SqlName as %RawString;
Specifies an alternate name when this trigger is used by SQL.
Property methods: SqlNameGet(), SqlNameIsDefined(), SqlNameIsValid(), SqlNameReset(), SqlNameSet()
property TagGenerator as %RawString;
TagGenerator
Property methods: TagGeneratorGet(), TagGeneratorIsValid(), TagGeneratorSet()
property Time as %RawString [ SqlFieldName = _Time ];
Specifies whether the trigger is fired before or after the EVENT.
Property methods: TimeGet(), TimeIsDefined(), TimeIsValid(), TimeReset(), TimeSet()
property UpdateColumnList as %RawString;
Specifies one or more columns whose modification causes the trigger to be pulled by SQL.
Property methods: UpdateColumnListGet(), UpdateColumnListIsDefined(), UpdateColumnListIsValid(), UpdateColumnListReset(), UpdateColumnListSet()
relationship parent as %Dictionary.CompiledClass [ Required , Inverse = Triggers , Cardinality = parent ];
Pointer to the containing parent object
Property methods: parentCheck(), parentDelete(), parentGet(), parentGetObject(), parentGetObjectId(), parentGetSwizzled(), parentIsValid(), parentNewObject(), parentOnDelete(), parentRClose(), parentRExec(), parentRFetch(), parentRelate(), parentSQLCompute(), parentSet(), parentSetObject(), parentSetObjectId(), parentUnRelate(), parentUnSwizzle()

Methods

classmethod %Exists(oid As %ObjectIdentity) as %Boolean [ Language = objectscript ]
Inherited description: Checks to see if the object identified by the OID oid exists in the extent.

Returns %Boolean TRUE if it exists, FALSE if it does not.

classmethod %LockId(id As %String, shared As %Boolean = 0, timeout As %Integer) as %Status [ Language = objectscript ]
Inherited description: Obtain an exclusive or shared lock on the object identified by id. The type of lock obtained is determined by shared. This method is normally generated by the storage class for persistent classes using %Storage.Persistent or %Storage.SQL.
classmethod %UnlockId(id As %String, shared As %Boolean = 0, immediate As %Boolean = 0) as %Status [ Language = objectscript ]
Inherited description: Release an exclusive or shared lock on the object identified by id. The type of lock released is determined by shared. If this method is not overridden then the default implementation returns an error. This method is normally generated by the storage class for persistent classes using %Storage.Persistent or %Storage.SQL.
method CodeIsDefined() as %Boolean [ Language = objectscript ]
method CodeModeIsDefined() as %Boolean [ Language = objectscript ]
method CodeModeReset() [ Language = objectscript ]
method CodeModeSet(value As %String = "") as %Status [ Language = objectscript ]
method CodeReset() [ Language = objectscript ]
method CodeSet(value As %String = "") as %Status [ Language = objectscript ]
method DeprecatedIsDefined() as %Boolean [ Language = objectscript ]
method DeprecatedReset() [ Language = objectscript ]
method DeprecatedSet(value As %String = "") as %Status [ Language = objectscript ]
method DescriptionIsDefined() as %Boolean [ Language = objectscript ]
method DescriptionReset() [ Language = objectscript ]
method DescriptionSet(value As %String = "") as %Status [ Language = objectscript ]
method EventIsDefined() as %Boolean [ Language = objectscript ]
method EventReset() [ Language = objectscript ]
method EventSet(value As %String = "") as %Status [ Language = objectscript ]
method FinalIsDefined() as %Boolean [ Language = objectscript ]
method FinalReset() [ Language = objectscript ]
method FinalSet(value As %String = "") as %Status [ Language = objectscript ]
method ForeachIsDefined() as %Boolean [ Language = objectscript ]
method ForeachReset() [ Language = objectscript ]
method ForeachSet(value As %String = "") as %Status [ Language = objectscript ]
method InternalIsDefined() as %Boolean [ Language = objectscript ]
method InternalReset() [ Language = objectscript ]
method InternalSet(value As %String = "") as %Status [ Language = objectscript ]
method LanguageIsDefined() as %Boolean [ Language = objectscript ]
method LanguageReset() [ Language = objectscript ]
method LanguageSet(value As %String = "") as %Status [ Language = objectscript ]
method NameIsDefined() as %Boolean [ Language = objectscript ]
method NameReset() [ Language = objectscript ]
method NameSet(value As %String = "") as %Status [ Language = objectscript ]
method NewTableIsDefined() as %Boolean [ Language = objectscript ]
method NewTableReset() [ Language = objectscript ]
method NewTableSet(value As %String = "") as %Status [ Language = objectscript ]
method OldTableIsDefined() as %Boolean [ Language = objectscript ]
method OldTableReset() [ Language = objectscript ]
method OldTableSet(value As %String = "") as %Status [ Language = objectscript ]
method OrderIsDefined() as %Boolean [ Language = objectscript ]
method OrderReset() [ Language = objectscript ]
method OrderSet(value As %String = "") as %Status [ Language = objectscript ]
method SequenceNumberIsDefined() as %Boolean [ Language = objectscript ]
method SequenceNumberReset() [ Language = objectscript ]
method SequenceNumberSet(value As %String = "") as %Status [ Language = objectscript ]
method SqlNameIsDefined() as %Boolean [ Language = objectscript ]
method SqlNameReset() [ Language = objectscript ]
method SqlNameSet(value As %String = "") as %Status [ Language = objectscript ]
method TimeIsDefined() as %Boolean [ Language = objectscript ]
method TimeReset() [ Language = objectscript ]
method TimeSet(value As %String = "") as %Status [ Language = objectscript ]
method UpdateColumnListIsDefined() as %Boolean [ Language = objectscript ]
method UpdateColumnListReset() [ Language = objectscript ]
method UpdateColumnListSet(value As %String = "") as %Status [ Language = objectscript ]
classmethod parentOnDelete(id As %String, concurrency As %Integer) as %Status [ Language = objectscript ]

Indexes

index (IDKEY on Name) [IdKey, Type = key];
Index methods: IDKEYCheck(), IDKEYDelete(), IDKEYExists(), IDKEYOpen(), IDKEYSQLCheckUnique(), IDKEYSQLExists(), IDKEYSQLFindPKeyByConstraint(), IDKEYSQLFindRowIDByConstraint()

Triggers

trigger OnDelete (BEFORE event DELETE);
trigger OnInsertUpdate (BEFORE event INSERT/UPDATE);

Inherited Members

Inherited Methods

FeedbackOpens in a new window