Delete multiple records

Applies to User Roles:

System Administrator

Example: Delete the contacts for advantage with a variant of NewAdvantage as the contact name.

To delete all records with a specified value:

  1. Click Tailoring > Database Manager.
  2. Select Administration mode.
  3. For this example, open the contacts form.
  4. Enter the desired value. For this example, type NewAdvantage* in the Contact Name field.
  5. Click Search.

    Database Manager performs the search and displays the record list of matching records, if any, in the contacts.qbe form.

    If the query produces no matching records or only one matching record, then Service Manager does not display a record list.

    Note: To display the Mass function buttons, use a query that returns more than one record.

  6. Select Mass Delete from the tool bar to remove the records shown in the record list from the database.

    Database Manager confirms the delete request with a prompt screen.

  7. Do one of the following:
    • To cancel the delete, click No.
    • To confirm the delete, click Yes.

      Database Manager deletes all records in the list.

      Note: Service Manager performs the Mass Delete function in the foreground, which means your terminal is devoted to this function until complete. If you are deleting a large number of records, this can take a while.

Upon completion, Service Manager returns terminal control to you. A blank contacts form opens with the message: “nnn records deleted from the contacts file”, where nnn is the number of records deleted.

The topics below comprise an example of how to use multiple-record functions. Follow the steps in this order. If you skip a step, the example will not work.

  1. Add multiple records using a literal value
  2. Add multiple records using a variable value
  3. Update multiple records using a literal value
  4. Update multiple records using a variable value
  5. Avoid invalid duplicate or null key errors
  6. Delete multiple records

Related topics

Multiple-record functions

Determine the number of records in a record list
Open a record using Database Manager