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.

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.