Working with Data Models › Macro Toolbox › Entity Macros › %ForEachViewColumn()

%ForEachViewColumn()

Expands the macro code for each of the columns in the view.

Syntax

%ForEachViewColumn() {

<macro code>

}

Syntax Example

%ForEachViewColumn() {

%ViewColumnName

}

Expansion

renting_customer

master_number

movie_copy_number

rental_record_date

rental_date

due_date

rental_status

payment_amount

payment_date

payment_status

overdue_charge

Full Syntax

%ForEachViewColumn(<table>,<separator>,<sort order>) {

<macro code>

}

Full Syntax Example

%ForEachViewColumn(Parent, ", ") {%ViewColumnName}

Expansion

master_number, movie_copy_number, general_condition

Usage

Classified as an Entity macro that you can use in the Table Trigger Editor (Triggers dialog). A view must be in scope. <table> can be Parent or Child (if a relationship is in scope), or empty. <separator> is optional.