Table Properties

Table Properties: if the item is a Table name or an Unselected Field, the Properties dialog box allows you to modify the Alias name to be used for the table name.

Note that it is also possible to use a parameter for a table name. To do so, create a Parameter using the String (or Unknown) Type that will be feed directly by the full table name including the path (library for an AS/400 for example) or by the result of a formula.

For example a first parameter Param_Library, as string type, could ask for the Library Name only (among a list) and another parameter Param_Library_Table, as string type, could be the result of a formula that will concatenate the selected library name using the first parameter and a fixed table name. (= Param_Library + ‘.Table_Name’). Note here that the separator between the Library and the Table is a dot that will be translated by ClicknDECiDE Builder as a slash. The box “Parameter” in the above Properties dialog box can thus receive the value of the parameter “Param_Library_Table“ as string type.

See also: Query Properties

See also: Selected Field Properties