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

%ChildAtts()

Lists all the attributes of the child entity in a relationship and performs the specified action on each.

Syntax

%ChildAtts()

Syntax Example

%ChildAtts()

Expansion

renting_customer, master_number, movie_copy_number, rental_record_date, rental_date, and so on

Full Syntax

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

Full Syntax Example

/*If the current relationship is <is in stock as>, then */

%ChildAtts(" or ",update,%Child)

Expansion

update(MOVIE_RENTAL_RECOR.renting_customer) or

update(MOVIE_RENTAL_RECOR.master_number) or

update(MOVIE_RENTAL_RECOR.movie_copy_number) or

update(MOVIE_RENTAL_RECOR.rental_record_date) or

update(MOVIE_RENTAL_RECOR.rental_date) and so on

Usage

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