Working with Data Models › Macro Toolbox › Relationship Macros › %ParentCols()

%ParentCols()

Lists all the columns of the parent table in a relationship and performs the specified action on each.

Syntax

%ParentCols()

Syntax Example

%ParentCols()

Expansion

master_number, movie_copy_number, general_condition

Full Syntax

%ParentCols(<separator>, <function>,<prefix>)

Full Syntax Example

%ParentCols(" or",updating,%Parent)

Expansion

updating(MOVIE_COPY.master_number) or

updating(MOVIE_COPY.movie_copy_number) or

updating(MOVIE_COPY.general_condition)

Usage

Classified as a Relationship macro that you can use in RI Override, Rel Override, %ForEachParentRel, %ForEachChildRel.