Reference an SQL Access from a Business Process by adding it to the Business Process
and creating variables or parameters for the object.
-
In the Business Process editor, under the Script section, click
the Add button.
-
Under the Task column, click Click to select task. In the
selector window, type sql in the filter field to show only the SQL
Access objects.
-
Double-click the SQL Access object to be referenced.
-
With the SQL Access object task highlighted, specify the value for its
parameters in the Properties view. These values will correspond to the
parameters set in the SQL Access editor.
-
Click Click to Set Value in the first parameter.
- If the parameter should be populated with an already existing
variable or parameter, select that variable or parameter.
- If the parameter is an output parameter and an existing variable
doesn't exist, create a New Variable or New Parameter. In
the (Parameters or Variables) area, type a Name for it,
define its Type, and, if necessary, assign an Initial
Value.
- If hard coding a constant value into the parameter, click the
String Literal tab and type your constant value into the field.
(only for input parameters)
-
Press
Enter.Repeat this step for each parameter.
-
With the SQL Access object task highlighted, use the Up and Down
arrows to move it to the correct position in its sequence.
-
In the Label column, type a label for this task.