Welcome > Form Designer module > Add actions to a form or control > Add actions > Create a DB query > DB Query to update database records

DB Query to update database records

  1. On the DB Query Action page of a form, or on the Extended Properties page of a Data Access activity, click Configure.
    The Database Query page appears.
    Note By default, Tables is selected and all tables within the selected database are available on the Table list.
  2. On the Table list, select the table to update records for. All the columns within the selected table appear.
  3. For Record, click Update.
  4. On the All Columns list, select the columns to update records for, such as ContactName, Address, and Phone.
  5. To perform multiple updates, click Perform Multiple Updates check box.
  6. Configure your query based on specific conditions.

    Example

    To retrieve the ContactName, Address, and Phone records for the cities of London and Berlin, specify the condition as:

    1. Column: City(String), Operator: Equal To, Criteria: London, Logic: AND.

    2. Click Add Add.

    3. Column: City(String), Operator: Equal To, Criteria: Berlin.

    4. Click Add Add.

  7. Click OK.
  8. Click Close.