L12 - Database Checkpoint

Database Checkpoint

Database checkpoint is used to check database values at run time.
To create database checkpoint

Step 1

Goto Menu ->  Insert -> Checkpoint -> Database Checkpoint

Step 2

Database Query wizard will open.
Select "Create query using Microsoft query".

Press Next

Step 3

Press Ok.

Step 4

Select MS Access database as per are taking example with MS access database.

Step 5

Select the database that is being used.

Step 6 

Select any table with some fields.

Step 7

Put conditions for query.

Step 8

Select option "Exit and return to Quick test professional'

Step 9

There are 2 buttons on right side.

These buttons are used to check and un check any value

We can configure the values in the bottom part of window as per our choice, either constant or parameter.

Code is generated as below:

DbTable("DbTable_2").Check CheckPoint("DbTable_2")

Run the test , it will pass , change the values in the table it will fail.