Repeats a statement for each alternate key in a table
.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) |
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',
For columns, the macro AKCOLN only accepts the variable %COLUMN%.