Macro Toolbox › Relationship Macros › %ChildPK()

Previous Topic: %ChildNKDecl()

Next Topic: %ChildPKDecl()

%ChildPK()

Lists primary key elements of the child table, and performs the specified action on each.

Syntax

%ChildPK()

Syntax Example

%ChildPK()

Expansion

renting_customer, master_number, movie_copy_number, rental_record_date

Full Syntax

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

Full Syntax Example

%ChildPK(" or",updating,%Child)

Expansion

updating(MOVIE_RENTAL_RECOR.renting_customer) or

updating(MOVIE_RENTAL_RECOR.master_number) or

updating(MOVIE_RENTAL_RECOR.movie_copy_number) or

updating(MOVIE_RENTAL_RECOR.rental_record_date)

Usage

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