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

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

1a.jpg

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

2a.jpg

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.

1.JPG

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.

2.jpg

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.

3.jpg

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.