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

%ForEachAtt()

Expands the macro code for each of the attributes in an entity, and columns in a table.

Note: This macro is a legacy macro. Depending on your model type, we recommend that you use either %ForEachColumn() or %ForEachAttribute() for new models. For information on legacy macros and their related new macros, see the topic "Legacy Macros."

Syntax

%ForEachAtt() {

<macro code>

}

Syntax Example

%ForEachAtt() {

%attFieldName

}

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

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

<macro code>

}

Full Syntax Example

%ForEachAtt(Parent, ", ") {%AttFieldName}

Expansion

master_number, movie_copy_number, general_condition

Usage

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