Insert multiple records into a database

Use the Perform Multiple Inserts check box to insert multiple records into a database table. Select to insert either all data or specific data from the selected rows. For example, you can select to add records for all new accounts (clients) to a bank customer database, or add records only for clients who reside in New York.

Note The Perform Multiple Inserts option is not available for process maps (Data activity).

The following table defines the outcome of different selection criteria.

Selection Criteria	DB Query Outcome
Select the Perform Multiple Inserts check box. Use only form controls excluding the table.	A single row is inserted into the database table.
Select the Perform Multiple Inserts check box. Do not select the Insert Selected Rows option. Do not select rows in the form table.	Multiple rows are inserted into the database table.
Select the Perform Multiple Inserts check box. Do not select the Insert Selected Rows option. Select one row in the form table.	Even though one row is selected, all rows are inserted into the database table.
Select the Perform Multiple Inserts check box. Do not select the Insert Selected Rows option. Select multiple rows in the form table.	Multiple rows are inserted into the database table.
Select the Perform Multiple Inserts check box. Select the Insert Selected Rows option. Do not select rows in the form table.	No data is populated into the database table.
Select the Perform Multiple Inserts check box. Select the Insert Selected Rows option. Select one row in the form table.	One row is inserted into the database table.
Select the Perform Multiple Inserts check box. Select the Insert Selected Rows option. Select multiple rows in the form table.	Multiple rows are inserted into the database table.
Do not select the Perform Multiple Inserts check box. Do not select rows in the form table.	No data is inserted into the database table.
Do not select the Perform Multiple Inserts check box. Select one row in the form table.	One row is inserted into the database table.
Do not select the Perform Multiple Inserts check box. Select multiple rows in the form table.	Even though multiple rows are selected, only the last selected row is inserted into the database table.
Select the Perform Multiple Inserts check box. Do not select the Insert Selected Rows option. Select one row in the form table. Add the DB Query action to the OnSelectRow event of the table.	Multiple rows are inserted into the database table.
Select the Perform Multiple Inserts check box. Select the Insert Selected Rows option. Select multiple rows in the form table. Add the DB Query action to the OnSelectRow event of the table.	Multiple rows are inserted into the database table.
Do not select the Perform Multiple Inserts check box. Select multiple rows in the form table.	One row is inserted into the database table.

Your search for {searchVal} returned {total} results.

Insert multiple records into a database