Table and DB Checkpoints:

Table and DB Checkpoints:

Ans : By adding table checkpoints to your tests or components, you can check that a specified value is displayed in a cell in a table on your application. By adding database checkpoints to your
tests or components, you can check the contents of databases accessed by your application.

The results displayed for table and database checkpoints are similar. When you run your test or
component, QuickTest compares the expected results of the checkpoint to the actual results of
the run session. If the results do not match, the checkpoint fails.

You can check that a specified value is displayed in a cell in a table by adding a table
checkpoint to your test or component. For ActiveX tables, you can also check the properties of
the table object. To add a table checkpoint, you use the Checkpoint Properties dialog box.

Table checkpoints are supported for Web and ActiveX applications, as well as for a variety of
external add-in environments.

You can use database checkpoints in your test or component to check databases accessed by your Web site or application and to detect defects. You define a query on your database, and then
you create a database checkpoint that checks the results of the query.

Database checkpoints are supported for all environments supported by QuickTest, by default, as
well as for a variety of external add-in environments.

There are two ways to define a database query:

(a) Use Microsoft Query. You can install Microsoft Query from the custom installation of Microsoft
Office.

(b) Manually define an SQL statement.

The Checkpoint timeout option is available only when creating a table checkpoint. It is not
available when creating a database checkpoint