Understanding the Database Checkpoint Properties Dialog Box in QTP in Testing

The Table/Database Checkpoint Properties dialog box enables you to specify which cell contents of your table or database to check and which verification method and type to use. You can also edit or parametrize the expected data for the cells included in the check. The top part of the Table/Database Checkpoint Properties dialog box displays the data that was captured for the checkpoint. You use this area to specify which cells you want to check.

Below the expected data, the Table/Database Checkpoint dialog box contains the following three tabs:

Expected Data

Enables you to set each checked cell as a constant or parametrized value. For example, you can instruct QuickTest to use a value from the Data Table As the expected value for a particular cell.

1.JPG

Settings

Enables you to set the criteria for a successful match between the expected and actual values. For example, you can instruct QuickTest to treat the value as a member so that 45 or 45.00 are treated as the same value, or you can instruct QuickTest to ignore spaces when comparing the values.

2.JPG

Cell Identification

Enables you to specify how QuickTest locates the cells to be checked. However, be aware that each time you run your test or component, it is possible that the rows may be in a different order, depending on the sorting that was performed in a previous step. Therefore, rather than finding the data based on row and column numbers, you may want QuickTest to identify the cell based on the column name and the row containing a known value in a key column.

data2.jpg