Show Hide

 

Feedback

  • Contents
 

Database Action – Update Row(s)

Use the Edit Update Rows dialog to change values in selected rows of a database table.

When you pass values to a standard database action such as this one, do not use the ToSql() function to convert the values. IPA Designer does any required conversion automatically. If you use ToSql() with standard database actions, it causes an error.

Note: To access CIC Data Sources in your process designs, you must have the user rights to access them. If you get an error message when you try to access a data source from a process design, contact your system administrator to obtain the required user rights. Users of the process must also have rights to access the data sources.

To create an SQL UPDATE statement:

  1. In the Update this Table list box, select the desired database table.

  2. On the Conditions tab, select a column in the Columns list box.

  3. Click the Plus icon to add a condition (see figure).

New Variable: Lets you create a new variable to use for the criterion value.

Value List Box: Displays the Value list box, in which you can choose to use a literal value, a variable, or a calculation.

  1. In the Op list box, select a Boolean operator to use.

  1. In the Value column, enter a value to use as a selection criterion. Either:

  • Click the Value List Box icon to enter a literal text value, a variable, or a calculation.

  • Click the New Variable icon to create a new variable for the value.

Tip: When the New Variable icon is available, you can also type in the box to find a variable or use the drop-down list to browse for a variable.

  1. Repeat steps 3-5 to add more selection criteria if needed. If you have multiple criteria, select the AND or OR radio button.

  2. On the Values tab (see figure):

New Variable: Lets you create a new variable to use for the criterion value.

Value List Box: Displays the Value list box, in which you can choose to use a literal value, a variable, or a calculation.

  • In the Available Columns list box, select the column to update.

  • In the Value text box, enter a value (or NOT_SET) to insert into the column.

  1. Repeat step 7 to update additional columns as desired.

  2. Configure Errors and Timeouts (see figure):

    1. Click the Errors and Timeouts tab.

    2. In the Timeout Duration text box, enter the amount of time that the process should try to do the database action before giving up.

    3. Select the radio buttons for the desired timeout and error handling methods.

  3. If desired, click the Notes tab and add notes about the database action. Then click Close.