# aCol (Trigger Template)
- Syntax:
#aCol
- Template Text:
- Text Description:
-
The name of the current column (inside the template text of #AllCols)
- GUID:
82d4bab5-3b1c-11d5-a5f5-004095d229e6
# Action (Trigger Template)
- Syntax:
#Action
- Template Text:
- Text Description:
-
The name of the current action.
- GUID:
82d4ba96-3b1c-11d5-a5f5-004095d229e6
# AllActions (Trigger Template)
- Syntax:
#AllActions*(<Template Text>,<Separator>)
- Template Text:
- Text Description:
-
Expands the template text for each Action of the trigger.
Binds the following:
#Action <= the name of the action
(will be one of INSERT, UPDATE, DELETE)
- GUID:
82d4ba97-3b1c-11d5-a5f5-004095d229e6
# AllChildren (Trigger Template)
- Syntax:
-
#AllChildren*(<Template Text>)
- Example:
-
(When used in Entity P Table. N.B not valid SQL)
Example for table #Table
#AllChildren*(FKs of #Child are #AllFKs*(#anFK,, )
Expands to:
Example for table P_TABLE
FKs of C_2_TABLE are occupantorgcode, occupantcompany
FKs of C_1_TABLE are p_table_orgcode, co_company
- Template Text:
- Text Description:
-
Expands the text for each Child of the current entity
The following macro variables are bound by #AllChildren
#Child <= The name of the current Child
#FKList <= The list of foreign key components (of the Child)
- GUID:
82d4ba98-3b1c-11d5-a5f5-004095d229e6
# AllChildrenSep (Trigger Template)
- Syntax:
#AllSepChildren*(<separator text>,<Template Text>)
- Example:
-
(When used in Entity P Table. N.B not valid SQL)
Example for table #Table
#AllSepChildren*( or #cr,FKs of #Child are #AllFKs*(#anFK,, )
Expands to:
Example for table P_TABLE
FKs of C_2_TABLE are occupantorgcode, occupantcompany or
FKs of C_1_TABLE are p_table_orgcode, co_company
- Template Text:
- Text Description:
-
Expands the text for each Child of the current entity with each Child Entity Name separated by the separator.
The following macro variables are bound by #AllSepChildren
#Child <= The name of the current Child
#FKList <= The list of foreign key components (of the Child)
- GUID:
82d4ba99-3b1c-11d5-a5f5-004095d229e6
# AllColumns (Trigger Template)
- Syntax:
-
#AllColumns(<Template Text)
#AllColumns(<Template Text)
Syntax:
#AllColumns(<Template Text)
- Example:
-
Example from Entity P Table
Example for #Table
#AllColumns*(
Name = #aCol, Type = #SQLType, Nullability = #SQLNULL,
Length = #Length, Decimals = #Decimals, Raw Type = #SQLTypeRaw
)
Expands to:
Example for P_TABLE
Name = manager, Type = int, Nullability = NOT NULL,
Length = 9, Decimals = , Raw Type = NUMERIC
Name = orgcode, Type = char (4), Nullability = NOT NULL,
Length = 4, Decimals = , Raw Type = CHARACTER
Name = co_company, Type = int, Nullability = NOT NULL,
Length = 5, Decimals = , Raw Type = NUMERIC
- Template Text:
- Text Description:
-
Expands the template text for each column of the table generated from the entity.
AllColumns binds the following macro variables
#aCol <= the name of the column
#SQLType <= The type (and qualifiers) of the data type of the column
#SQLNULL <= The NULLITY of the column
#Default <= The Default Value of the column
#Length <= The Length (Precision) of the column
#Decimals <= The Decimals of the column(N.B. Length and Decimals are derived from the contents of the SQL Type Qualifiers property)
#SQLTypeRaw <= The SQL Data Type property
- GUID:
82d4ba9a-3b1c-11d5-a5f5-004095d229e6
# AllFks (Trigger Template)
- Syntax:
-
#AllFks*(<Template Text>,<Separator>)
- Example:
-
#AllChildren*(
Foreign Keys of Child #Child are:
#AllFks*(#anFK,, )
)
Expands to:
Foreign Keys of Child C_2_TABLE are:
occupantorgcode, occupantcompany
Foreign Keys of Child C_1_TABLE are:
p_table_orgcode, co_company
- Template Text:
- Text Description:
-
Expand the first argument for each foreign key component, binding #anFK to its name.The components are separated by the second argument.
May be used only inside AllChildren or AllParents
- GUID:
82d4ba9b-3b1c-11d5-a5f5-004095d229e6
# AllParentPks (Trigger Template)
- Syntax:
-
#AllParentPks*(<template text>,<separator text>)
- Example:
-
Example for entity #Table
#AllParents*(
For Parent Table #Parent the Primary Keys are
#AllParentPks*(#aPK,, )
)
Expands to:
Example for entity P_TABLE
For Parent Table G_P_TABLE the Primary Keys are
ssn
For Parent Table CO the Primary Keys are
company
(a_item_no, a_purchase_officer_id, action_taken) ...
- Template Text:
- Text Description:
-
The Template Text will be expanded for each primary key column of the current parent table, when processing AllPArents
The variable #aPK will be bound to the name of the current primary key field.
The <separator text> will be inserted between the instances of the <template text>.
- GUID:
82d4ba9c-3b1c-11d5-a5f5-004095d229e6
# AllParents (Trigger Template)
- Syntax:
#AllParents*(<Template Text>)
- Example:
-
The parents of #Table are
#AllParents*( #Parent
)
Expands to:
The parents of P_TABLE are
G_P_TABLE
CO
- Template Text:
- Text Description:
-
Expands the text for each Parent of the current entity. The following macro variables are bound by #AllParents
#Parent <= The name of the current Parent
#ParentPKList <= The list of primary keys of the parent
- GUID:
82d4ba9d-3b1c-11d5-a5f5-004095d229e6
# AllParentsSep (Trigger Template)
- Syntax:
#AllSepParents*(<separator text>,<Template Text>)
- Example:
-
The parents of #Table are
#AllParents*(or #CR, #Parent
)
Expands to:
The parents of P_TABLE are
G_P_TABLE or
CO
- Template Text:
- Text Description:
-
Expands the text for each Parent of the current entity. The following macro variables are bound by #AllParents
#Parent <= The name of the current Parent
#ParentPKList <= The list of primary keys of the parent
- GUID:
82d4ba9e-3b1c-11d5-a5f5-004095d229e6
# AllPks (Trigger Template)
- Syntax:
#AllPks*(<template text>,<separator text>)
- Example:
-
if #AllPKs*(update (#aPK), or #cr )
Expands to:
if update (orgcode) or
update (co_company)
if update (a_item_no) or
update (a_purchase_officer_id)
begin
...
- Template Text:
- Text Description:
-
The Template Text will be expanded for each primary key column of the current table.
The variable #aPK will be bound to the name of the current primary key field.
The <separator text> will be inserted between the expanded instances of the <template text>.
- GUID:
82d4ba9f-3b1c-11d5-a5f5-004095d229e6
# AllPksFks (Trigger Template)
- Template Text:
- Text Description:
-
The first argument MUST be either PKList or ParentPKList.
The Second argument is then expanded for each entry in the Primary Key List and each entry in #FKList. The Third argument is a separator inserted between expansions. AllPksFks binds
#aPK <= the name of the current Primary Key component
#anFK <= the name of the current Foreign Key component
- GUID:
82d4baa0-3b1c-11d5-a5f5-004095d229e6
# anFK (Trigger Template)
- Syntax:
#anFK
- Template Text:
- Text Description:
-
The Name of the current Foreign Key Component (inside the template text of #AllFKs and #AllFkPks)
- GUID:
82d4bab7-3b1c-11d5-a5f5-004095d229e6
# aPK (Trigger Template)
- Syntax:
#aPK
- Template Text:
- Text Description:
-
The name of the current Primary Key column (inside the template text of AllPks and AllPkFks)
- GUID:
82d4bab6-3b1c-11d5-a5f5-004095d229e6
# Child (Trigger Template)
- Template Text:
- Text Description:
-
Expands to the name of the current child entity when processing AllChildren
- GUID:
82d4baa1-3b1c-11d5-a5f5-004095d229e6
# DB2 - default trig hdr (Trigger Template)
- Syntax:
#defDB2TrigHeader
- Template Text:
- Text Description:
-
Generates a header of the form
create trigger <trigger name> <time> <actions> on <table name>
- GUID:
82d4baa2-3b1c-11d5-a5f5-004095d229e6
# DB2 - default trig tlr (Trigger Template)
- Syntax:
#defDB2TrigTrailer
- Template Text:
- Text Description:
Generates a trailer of the form ;
- GUID:
82d4baa3-3b1c-11d5-a5f5-004095d229e6
# ForEachRowClause (Trigger Template)
- Syntax:
#ForEachRowClause
- Template Text:
- Text Description:
-
ORACLE ONLY
Expands to FOR EACH ROW or is empty depending on whether the trigger's For Each Row property is true.
- GUID:
82d4baa4-3b1c-11d5-a5f5-004095d229e6
# Informix - default trig hdr (Trigger Template)
- Template Text:
- Text Description:
-
Generates a header of the form
create trigger <trigger name>_<table name> <actions> ON <table name>
- GUID:
82d4baa5-3b1c-11d5-a5f5-004095d229e6
# Informix - default trig tlr (Trigger Template)
- Syntax:
#defInformixTrigTrailer
- Template Text:
- Text Description:
Generates a trailer of the form ';'
- GUID:
82d4baa6-3b1c-11d5-a5f5-004095d229e6
# Interbase - default trig hdr (Trigger Template)
- Template Text:
- Text Description:
-
Generates a header of the form
create trigger <trigger name>_<table name> for <table name>
<active> <actions> <position> as
- GUID:
82d4baa7-3b1c-11d5-a5f5-004095d229e6
# Interbase - default trig tlr (Trigger Template)
- Syntax:
#defInterbaseTrigTrailer
- Template Text:
- Text Description:
Generates a trailer of the form ';'
- GUID:
82d4baa8-3b1c-11d5-a5f5-004095d229e6
# Length (Trigger Template)
- Template Text:
- Text Description:
-
The Length (Precision) of the column. (inside AllCols)
- GUID:
82d4baa9-3b1c-11d5-a5f5-004095d229e6
# Oracle - default trig hdr (Trigger Template)
- Syntax:
#defORATrigHeader
- Template Text:
- Text Description:
-
Generates a header of the form
create trigger <trigger name> <time> <actions> on <table name>
- GUID:
82d4baaa-3b1c-11d5-a5f5-004095d229e6
# Oracle - default trig tlr (Trigger Template)
- Syntax:
#defORATrigTrailer
- Template Text:
- Text Description:
Generates a trailer of the form ;
- GUID:
82d4baab-3b1c-11d5-a5f5-004095d229e6
# Parent (Trigger Template)
- Template Text:
- Text Description:
-
The name of the current parent when processing AllParents
- GUID:
82d4baac-3b1c-11d5-a5f5-004095d229e6
# raiserror (Trigger Template)
- Syntax:
#raiserror(<when>)
- Template Text:
- Text Description:
-
- GUID:
82d4bab8-3b1c-11d5-a5f5-004095d229e6
# SQL Srvr - default trig hdr (Trigger Template)
- Syntax:
-
#defSQSTrigHeader
- Template Text:
-
- Text Description:
-
Generates a header of the form
create trigger <trigger name> on <table name> for <actions>
- GUID:
82d4baad-3b1c-11d5-a5f5-004095d229e6
# SQL Srvr - default trig tlr (Trigger Template)
- Syntax:
#defSQSTrigTrailer
- Template Text:
- Text Description:
-
Generates a trailer of the form go
- GUID:
82d4baae-3b1c-11d5-a5f5-004095d229e6
# SQLNULL (Trigger Template)
- Syntax:
#SQLNULL
- Template Text:
- Text Description:
-
The NULLITY of the column, mapped appropriately for the current SQL Product. (inside AllCols)
- GUID:
82d4baaf-3b1c-11d5-a5f5-004095d229e6
# SQLType (Trigger Template)
- Template Text:
- Text Description:
-
The type (and qualifiers) of the data type of the column, mapped appropriately for the current SQL Product. (inside AllCols)
- GUID:
82d4bab0-3b1c-11d5-a5f5-004095d229e6
# SQLTypeRaw (Trigger Template)
- Template Text:
- Text Description:
-
The SQL Data Type property of the column. Unmapped. (inside AllCols)
- GUID:
82d4bab1-3b1c-11d5-a5f5-004095d229e6
# Table (Trigger Template)
- Syntax:
#Table
- Template Text:
- Text Description:
-
The name of the Table being generated.
- GUID:
82d4bab2-3b1c-11d5-a5f5-004095d229e6
# Tablename (Trigger Template)
- Syntax:
#Tablename
- Template Text:
- Text Description:
-
The name of the Table being generated (without owner).
- GUID:
0921f3fc-b9a9-11d5-830e-0050da1aba7b
# theFKsCS (Trigger Template)
- Syntax:
-
#theFKsCS
- Template Text:
- Text Description:
-
A comma separated list of the current foreign keys.
- GUID:
82d4bab9-3b1c-11d5-a5f5-004095d229e6
# theParentPKsCS (Trigger Template)
- Syntax:
-
#theParentPKsCS
- Template Text:
- Text Description:
-
A comma separated list of the primary keys of the current parent of the table for which a trigger is being generated.
- GUID:
82d4babb-3b1c-11d5-a5f5-004095d229e6
# thePKsCS (Trigger Template)
- Syntax:
-
#thePKsCS
- Template Text:
- Text Description:
-
A comma separated list of the primary keys of the table for which a trigger is being generated.
- GUID:
82d4baba-3b1c-11d5-a5f5-004095d229e6
# TriggerName (Trigger Template)
- Syntax:
-
#TriggerName
- Template Text:
- Text Description:
-
The Name of the trigger whose template is being expanded.
- GUID:
82d4bab3-3b1c-11d5-a5f5-004095d229e6
# WhenClause (Trigger Template)
- Syntax:
-
#WhenClause
- Template Text:
- Text Description:
-
ORACLE ONLY
Expands to WHEN concatenated with the contents of the trigger's "When" property, or is empty if the property is empty.
- GUID:
82d4bab4-3b1c-11d5-a5f5-004095d229e6