Add Attribute Form statement

Adds a form with one expression to an attribute within a project.

Copy

ADD ATTRIBUTEFORM form_name [FORMDESC form_desc] FORMCATEGORY category_name FORMTYPE (NUMBER | TEXT | DATETIME | DATE | TIME | URL | EMAIL | HTML | PICTURE | BIGDECIMAL) [SORT (NONE | ASC | DESC)] EXPRESSION form_expression [MAPPINGMODE (AUTOMATIC | MANUAL)] [EXPSOURCETABLES sourcetable1, [,sourcetable2[, . . .sourcetableN]]] LOOKUPTABLElookup_table [MULTILINGUAL (TRUE | FALSE)] TO ATTRIBUTE attribute_name IN [FOLDER] location_path FOR PROJECT project_name;

where:

form_name is the name of the form to be added, of type string, between double quotes (").
form_desc is the description of the form, of type string, between double quotes (").
category_name is the category name to be used in the form, of type string, between double quotes (").
form_expression is the expression to be added to the form, of type string, between double quotes (").
sourcetableN is the name of the source table to be used in the form, of type string, between double quotes (").
lookup_table is the name of the lookup table to be used in the form, of type string, between double quotes (").
attribute_name is the name of the attribute to which a form is to be added, of type string, between double quotes (").
location_path is the folder where the attribute resides, of type string, between double quotes (").
project_name is the name of the project, of type string, between double quotes (").

This statement can only be executed in a Windows environment.

Example

Copy

ADD ATTRIBUTEFORM "Last Name" FORMDESC "Last Name Form" FORMCATEGORY "DESC" FORMTYPE TEXT SORT DESC EXPRESSION "[CUST_LAST_NAME]" LOOKUPTABLE "LU_CUSTOMER" TO ATTRIBUTE "Customer" IN FOLDER "\Schema Objects\Attributes" FOR PROJECT "MicroStrategy Tutorial";