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

%JoinPKPK()

Joins the primary key of two correlations, or a base table and a correlation. Returns the code supporting comparison of PK values of two tables.

Syntax

%JoinPKPK(<table>, <correlation>)

Syntax Example

%JoinPKPK(%Child,:%New)

Expansion

MOVIE_RENTAL_RECOR.renting_customer = :new.renting_customer and

MOVIE_RENTAL_RECOR.master_number = :new.master_number and

MOVIE_RENTAL_RECOR.movie_copy_number = :new.movie_copy_number and

MOVIE_RENTAL_RECOR.rental_record_date = :new.rental_record_date

Full Syntax

%JoinPKPK(<table>, <correlation>, <comparison op>,<separator>)

Full Syntax Example

%JoinPKPK(%Child,:New," <> "," or")

Expansion

MOVIE_RENTAL_RECOR.renting_customer <> :new.renting_customer or

MOVIE_RENTAL_RECOR.master_number <> :new.master_number or

MOVIE_RENTAL_RECOR.movie_copy_number <> :new.movie_copy_number or

MOVIE_RENTAL_RECOR.rental_record_date <> :new.rental_record_date

Usage

Classified as an Entity macro that you can use in the Table Trigger Editor (Triggers dialog). Also is a Relationship macro that you can use in RI Override or Rel Override, %ForEachParentRel, %ForEachChildRel.