%ForEachKey()

Expands the macro code for all alternate keys and inversion entries in the table (PK, AK, and IE keys).

Syntax

%ForEachKey([<table>],[<type>],[<name>],[<separator>]) {

}

<table> - by default, this macro is applied to the table in the current scope. This argument can be

used to name another table to loop through (for example, %Parent, MOVIE_COPY, and so on).

<type> - filter on type of key (such as AK, IE, AK1, and so on); default is all keys.

<name> - the name of a specific key group.

<separator> - the string to be placed between the table's keys.

Syntax Example

%ForEachKey {

%KeyName

}

Expansion

AK1

IE1

Usage

Classified as an Entity macro that you can use in the Table Trigger Editor (Triggers dialog).