.AKCOLN Macro

Repeats a statement for each alternate key in a table

Syntax

.AKCOLN("statement","prefix","suffix","last_suffix", "condition")

Argument

Description

statement

Statement to repeat for each column

prefix

Prefix for each new line

suffix

Suffix for each new line

last suffix

Suffix for the last line

condition

Alternate key code (if condition argument is left empty the macro returns a statement for each alternate key in the table)

Example

In a trigger for the table TITLEAUTHOR, the following macro:

message .AKCOLN("'%COLUMN% is an alternate key column'","", "", "", "AKEY1")

generates the following trigger script:

message 'TA_ORDER is an alternate key column',
Note:

For columns, the macro AKCOLN only accepts the variable %COLUMN%.