Specifying Which Cells to Check, Expected Data and Value Type Criteria in QTP in Testing

Select Database checkpoint from Insert > Checkpoint > Database Check point.

The Database Query Wizard window opens, enter the desired query in that.

Specifying which cells to check

The top part of the Table/Database checkpoint properties dialog box displays a grid representing the cells in the table or captured result set.



When you create a new table checkpoint, all cells contain a blue check mark, indicating they are all selected for verification. You can instruct Quick Test the entire table, specific rows, specific cells.



Specifying the Expected Data

The Expected Data tab displays options for setting the expected value of the selected cell in the table or result set.



Specifying the Value Type Criteria

The settings tab includes options that determine how the actual cell values are compared with the expected cell values. The settings in this tab apply to all selected cells.