Datasource name

Displays the name of the data source as it appears in Dialog Designer.

Operation

Displays the type of operation this file performs. For more information about operation types, see Create a Database Operation Page.

Distinct select

(Query operations only) Return only one record for all the records that have the same data in the returned columns.

Table name

Displays the name of the table in which the database operation is to operate.

Type

Displays whether the database operation performs within a table or executes a procedure.

Column Name

(Not in Execute operations - Display only) Displays the name of the column in which the operation is to be performed.

Parameter Name

(Execute operations only- Display only) Displays the names of all input and output parameters used by the stored procedure.

Parameter Type

(Execute operations only- Display only) Displays the type associated with each input and output parameter used by the stored procedure.

Data Type

Displays what type of data is contained within the column or parameter.

Note: This type helps determine what type of variable to use.

Variable Name

Displays the name of the variable currently mapped to this column or parameter. For information about remapping variables, see Remapping Variables to Columns.

Variable Field

Displays the name of the field associated with the variable if the variable selected in the Variable Name field is a complex variable.

Order By

(Query operations only) Displays order selections for the results to be returned. For more information about this field, see Determining Order for Return Results.

... button

To change a data source name, click this button. If the data source does not match the database schema, there will be runtime errors.