The Local DB Insert action inserts a row into a local database table.
Parameter descriptions
| Parameter | Description |
|---|---|
| Table | The name of the local database table selected to insert rows. The table name will be available from a drop-down list. To insert multiple rows, click on the Use Advanced Properties and follow the procedure below. |
Select the Use Advanced Properties to view the advanced properties. The following table describes the advanced properties parameters:
| Parameter | Description |
|---|---|
| Row Count | Enter the row count to be inserted. The value is a number in between 1 and 10000. |
Input tab
The Input tab will have one row per column in the database table, where each row is identified by the table column name.
| Parameter | Description |
|---|---|
| Table Column Name | Optional. The table column name. |
| Actual Row Count | Appears when the Row Count is greater than 1. Indicates one row gets updated at a time. |
Output tab
| Parameter | Description |
|---|---|
| Error Message | Optional. Used to provide information if the query fails. |