Macro Toolbox › Relationship Macros › %SetPK()

%SetPK()

Lists the primary key attribute name of the specified table and sets each member to the specified value.

Syntax

%SetPK(<table>,<value>)

Syntax Example

%SetPK(%Parent,NOT NULL)

Expansion

MOVIE_COPY.master_number = NOT NULL,

MOVIE_COPY.movie_copy_number = NOT NULL

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, Rel Override, %ForEachParentRel, %ForEachChildRel.