Creating a Checkpoint on a Database in QTP

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

da4.jpg

You can create a checkpoint for a database to check the contents of the entire result set, or a part of it. Quick Test captures the current data from the database, saves this information as expected data, and inserts a database checkpoint into the test. This checkpoint is displayed in the Expert view as a DBTable.CheckCheckPoint statement.

da2.jpg

And in keyword View

da3.jpg

When you run the test, 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. You can view the results of the checkpoint in the Test Results window.

da1.jpg