Configure a query to update database records.

1. On the properties panel of the Data access activity, click Configure.
   The Data access configuration - <Activity name> dialog box is displayed.
2. On the Database connection list, select the process or server variable to specify the database connection string that holds the details of the relational database.
3. On the Type list, select Tables.
   Note By default, Tables is selected and all tables within the selected database are available on the Tables list.
4. On the Tables list, select the table for which you want to update the records. All columns within the selected table appear under Available columns.
5. On the Record list, select Update.
6. On the Available columns list, select the columns and click .
7. To perform multiple updates, click Perform multiple updates check box.
   Note This option is available only if you create a DB query action on a form.
8. On the Return rows affected to list, select a variable.
9. Configure your query based on specific conditions. For example, to update the ContactName, Address, and Phone records for the cities of London and Berlin, do the following:

   1. Click  under Search criteria.

   2. Specify the search criteria as Column as City(String), Operator as equals, Criteria as London, and Logic as AND.

   3. Click Add .

   4. Click .

   5. Specify another search criteria as Column as City(String), Operator as equals, Criteria as Berlin, and Logic as AND.

   6. Click Add.

10. Click OK.