.NMFCOL Macro

Repeats a statement for each non-modifiable column in a table. Non-modifiable columns have Cannot Modify selected as a check parameter.

Syntax

.NMFCOL("statement","prefix","suffix","last_suffix")

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

Example

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

.NMFCOL("%COLUMN% %COLTYPE%","",",",";")

generates the following trigger script:

TITLE_ISBN char(12),
PUB_ID char(12);