Use the Map to Variables page of the Database Operation Wizard to:
- Select which columns or parameters to map to variables.
- Map columns in the data source to variables. When the Operation type is Add or Update, this mapping determines which variable values will be written to the database.
- Map parameters in the data source to variables. When the Operation type is Query, this mapping determines which records are retrieved from the database, the values of which the query operation stores in the mapped variables.
If Dialog Designer should not automatically create the variables to map to, custom variables must be created to map to before attempting to map any variables in the Database Operation Wizard. For information about creating custom variables, see Creating Variables.
The following table describes the options available in the Map to Variables page.
Database Operation File Wizard-Map to Variables Page Settings
|
Field
|
Description
|
Operation
|
|---|
Column Name
| Select the columns that will perform the operation.
| Add
Query
Update
|
Column Type
| Displays the database type for each column. This type helps determine what type of variable to use.
The database vendor defines the types for columns. For more information about the types, see your database documentation.
| Add
Query
Update
|
Parameter Name
| Displays the parameter names for inputs that the stored procedure expects to receive.
| Execute
|
Parameter Type
| Displays the type of the expected input parameter.
| Execute
|
Variable Name
| Select the variable to map the column or parameter to. If the variable is a complex variable, select a Variable Field.
If a variable is selected, the Auto Create option is not available.
| Add
Query
Update
Execute
|
Variable Field
| If the variable selected in the Variable Name field is a complex variable, select a field to map the column or parameter.
| Add
Query
Update
Execute
|
Auto Create
| Select this option to indicate that Dialog Designer should automatically create and name a variable to map the column or parameter to. If selected, the Variable Name and Variable Field fields are disabled.
| Add
Query
Update
Execute
|
Creating one complex variable for all the columns
| This option will create a complex variable with a field for each column, which helps keep variables used in the database operation grouped together. If this option is not selected, a simple variable will be created for each column.
| Add
Query
Update
Execute
|
Result set returned
| Also in case of creating the stored procedure operation that returns a resultset, you need to check the Result set returned option and specify the # of columns expected to return.
Then when you click Next, another Map to Variables page would come up and allow you to map the resultset column to variables.
| Add
Query
Update
Execute
|
After upadting the settings on this page, click Finish.
Dialog Designer creates the database operation file and places it in the following directory: <ProjectName>\connectivity\dboperations. A suffix of .dbop is assigned to the new database operation file.
Also, if the Open file for editing check box on the first page of the wizard was selected, the Database Operation File Editor is opened. See Using the Database Operation File Editor.
