# 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