602SQL Documentation Index  

Element Properties

The XML element properties window is displayed if you double-click either the begin or end tag of an element in the DAD design tree.

Dialog Description

Element name - You may change the element name here. The designer does not restrict the allowed character set, however it is recommended to use ASCII characters.

Join a new table here - Check this if the element makes a shell for the table content. Records from the joined table will be placed in XML as subelements of this element. An example of joining a table with an element can be found here.

Data source - Choose one item from the list of 602SQL servers or the list of open ODBC Data Sources. If empty, the 602SQL server in which the client is connected to will be used.

Schema - Choose one application from the list (if the data source is 602SQL) or schema (if the data source is ODBC Data Source). If empty, current open 602SQL application will be used.

Joined table - Choose one table from the list.

Alias - If this table will be used multiple times in the DAD, you must distinguish each occurrence (details can be found here).

Column of joined table, Upper table, Column of upper table - Data transferred from/to tables bound by referential integrity (details here).

Order by - Specify the expression that will be used for sorting records on output (for analytic DAD, details here).

Condition - You may limit the record set by using a logical condition on the table selected above (details about using variables in conditions can be found here).

Repeatable element - Allows repeating identical values before the element (details and example here).

Repeat on change of, Table, Column - Allows you to repeat elements (details and example here).

Element output condition - Defines the condition when the element (after fulfilling all previous restrictions) will be placed in the XML file (details here).