You can use an Application to retrieve data from a database or to insert data into the database. Database Checkpoints in a Test enable you to ensure that the application successfully retrieves or inserts data into a database.

A database CHECKPOINT stores the expected data and compares the expected data with the data stored in the database. You use a database checkpoint to confirm that the data stored in a database has not introduced errors in the application.

When executing a database checkpoint, the following events occur:

  1. The test arrives at the database checkpoint step and connects to the database.
  2. QuickTest sends a query to the database to retrieve the actual data.
  3. QuickTest gathers the result set of the query, which provides the actual data.
  4. QuickTest compares the actual data with the expected data, which is stored in the database checkpoint, to determine if the test passed or Failed.

Figure shows the events that occur when executing a database checkpoint.

Related posts:

  1. Understanding Checkpoints in QTP
  2. Inserting a Database Checkpoint in QTP
  3. Creating a Database Checkpoint in QTP
  4. Identifying a Failed Checkpoint
  5. Text Checkpoints for a Web Object in QTP