persistent class %Dictionary.TriggerDefinition
extends %Persistent, %Dictionary.TriggerDefinitionQuery
• parameter SQLENABLED = 1;
• property Code
as %CacheString;
The code that is executed when the trigger is fired.
• property Description
as %CacheString;
Specifies a description of the SQL trigger.
• property Event
as %CacheString;
Specifies the SQL event that will fire the trigger.
• property Final
as %Boolean [ InitialExpression = 0 ];
Specifies that subclasses cannot override the definition of the SQL trigger.
• property Foreach
as %CacheString;
Indicates if the trigger will be invoked for each row or for each statement
• property Internal
as %Boolean [ InitialExpression = 0 ];
If true, then do not display this item in automatic documentation.
• property Language
as %CacheString [ SqlFieldName = _Language ];
The language used to implement this trigger.
• property Name
as %Dictionary.CacheIdentifier;
The name of the SQL trigger.
• property NewTable
as %CacheString;
The name of the SQL table that holds old values for the trigger.
• property OldTable
as %CacheString;
The name of the SQL table that holds old values for the trigger.
• property Order
as %Integer [ InitialExpression = 0 ];
In the case of multiple triggers for the same EVENT and TIME, specifies the order in which the triggers should be fired.
• property SequenceNumber
as %Integer [ InitialExpression = 0 ];
SequenceNumber
• property SqlName
as %CacheString;
Specifies an alternate name when this trigger is used by SQL.
• property Time
as %CacheString [ SqlFieldName = _Time,InitialExpression = "BEFORE" ];
Specifies whether the trigger is fired before or after the EVENT.
• property UpdateColumnList
as %CacheString;
Specifies one or more columns whose modification causes the trigger to be pulled by SQL.
• relationship parent
as %Dictionary.ClassDefinition [ Inverse = Triggers,Cardinality = parent ];
Pointer to the containing parent object
• classmethod %Exists(oid As %ObjectIdentity)
as %Boolean
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)
as %Status
%LockId()
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 %Library.CacheStorage or %Library.CacheSQLStorage.
• classmethod %UnlockId(id As %String, shared As %Boolean = 0, immediate As %Boolean = 0)
as %Status
%UnlockId()
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 %Library.CacheStorage or %Library.CacheSQLStorage.
• classmethod EventIsValid(val As %String)
as %Status
• classmethod ForeachIsValid(val As %String)
as %Status
• classmethod LanguageIsValid(val As %String)
as %Status
• classmethod TimeIsValid(val As %String)
as %Status
• index (IDKEY on Name) [IdKey];
• trigger OnDelete
(AFTER event DELETE)• trigger OnInsertUpdate
(BEFORE event INSERT/UPDATE)
