DB Query to delete database records
-
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.Tables is selected and all tables within the selected database are available on the Table list.By default,
- On the Table list, select the table to delete records from. All columns within the selected table appear.
- For Record, click Delete.
-
Configure your query based on some specific conditions. For
example, to delete the records for the cities of London and Berlin, specify the
condition as:
-
Column: City(String), Operator: Equal To, Criteria: London, Logic: AND.
-
Click Add .
-
Column: City(String), Operator: Equal To, Criteria: Berlin.
-
Click Add .
-
- Click OK.
- Click Close.