Data View Editor (Magic xpa 4.x)

The Data View Editor lets you define the task's data view interface as part of the task definition. The Data View elements include source tables, fields, and range. This window replaces the Record Main from previous eDeveloper versions.

The Data View Editor lets you:

• Define the task's Main data source or Direct SQL statement.

• Link to other data sources.

• Define data source columns, Virtual variables, and parameters.

• Declare additional data sources.

You can enter the following two row types:

Header Row – This row lets you specify the data source type, define links to the data source, and declare (open) a data source. For each option, specific properties are displayed in the property sheet. The first header line defines whether the task has a Main data source or a Direct SQL statement.

Detail Row – This row, displayed under the Header row, lets you select:

• Remark

• Column – Displayed only when a Main Source is selected

• Virtual

• Parameter

You can copy and paste Data View lines across multiple tasks. For more details, see Copy Paste Logic and Data View Lines across Tasks. Since version: 4.6

Related Topics

Main Source Properties

Variable and Column Properties

Link Definition

Direct SQL Command

Range Window

Sort Window

How Do I Define a Program Data View?

Data View chapter in the Mastering Magic xpa guide