What is Database checkpoint in QTP?

You create a database checkpoint based on the results of the query (result set) you defined on a database.

Database checkpoint is displayed in the Expert View as a DbTable.Check CheckPoint statement.

When you run the test or component, the database checkpoint compares the current data in the database to the expected data defined in the Database Checkpoint Properties dialog box. If the expected data and the current results do not match, the database checkpoint fails. The results of the checkpoint can be viewed in the Test Results window.

To create a database checkpoint:

Choose Insert > Checkpoint > Database Checkpoint, The Database Query Wizard opens





Select your database selection preferences and click Next. If you chose Specify SQL statement in the previous step, the Specify SQL statement screen opens. Specify the connection string and the SQL statement, and click Finish.



The Checkpoint Properties dialog box opens. Select the checks to perform on the result set and click OK.