What is Database Checkpoints in QTP & How it Works?
You can use anto retrieve data from a database or to insert data into the database. Database in a enable you to ensure that the application successfully retrieves or inserts data into a database.
A databasestores 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:
- The test arrives at the database checkpoint step and connects to the database.
- QuickTest sends a query to the database to retrieve the actual data.
- QuickTest gathers the result set of the query, which provides the actual data.
- QuickTest compares the actual data with the expected data, which is stored in the database checkpoint, to determine if the test passed or .
Figure shows the events that occur when executing a database checkpoint.