Working with Data Models › Macro Toolbox › Entity Macros › %ForEachChildRel()

%ForEachChildRel()

Expands the <relationship code> for every relationship in which the trigger table is a child.

Syntax

%ForEachChildRel() {

<relationship code>

}

Syntax Example

%ForEachChildRel() {

insert into %Parent values(%ParentCols(", ",,new_)

}

Expansion

insert MOVIE_COPY values(new_master_number, new_movie_copy_number, new_general_condition)

Full Syntax

%ForEachChildRel(<separator>) {

<relationship code>

}

Full Syntax Example

%ForEachChildRel("go") {

insert into %Parent values(%ParentCols(", ",,new_)

}

Expansion

insert MOVIE_COPY values(new_master_number, new_movie_copy_number, new_general_condition)

Usage

Classified as an Entity macro that you can use to create a Trigger Override in the Table Trigger Editor (Triggers dialog).