Macro Toolbox › Entity Macros › %ForEachIndex()

%ForEachIndex()

Expands the macro code for all indexes in the current subject area. <table> defaults to the table in the current scope; can be used to name another table (%Parent, MOVIE_COPY).<type>filters type of index (AK, IE, IF, PK, AK1, IE2, and so on). Defaults to all index types.

Syntax

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

<macro code>

}

<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> - to filter on type of index (for example, AK, IE, IF, PK, AK1, IE2, and so on).

<name> - the name of a specific index.

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

Syntax Example

%ForEachIndex {

%IndexName %IndexType

}

Expansion

XPKMOVIE_COPY PK

Usage

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