Database Action – Insert Row(s)

Use the Insert Rows dialog to insert rows into an SQL 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 INSERT statement:

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

2. On the Values tab, choose the columns to include in the Insert operation (see figure).
   
   

• To add a column to the Insert operation, open the Available Columns list (1) and select the column. The list displays only columns that are not already in the selected columns list (2).

• To remove a column from the Insert operation, highlight its row in the selected columns list (2) and click the red X icon.

Note: Some tables have columns whose values automatically increment, so you should not include those columns in your Insert operation.

3. 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.

4. If desired, click the Notes tab and add notes about the database action.

5. Click Close.