Checkpoint Wizard - Selecting Data to Check (Database Table Checkpoints)

On the Select Data to Check page of the Checkpoint wizard, you can choose the fields whose data the Database Table checkpoint will verify.

1. By default, the checkpoint will verify all of the records that the wizard retrieves from the database. To limit the records number, select the Store only the specified number of rows check box and then enter the desired number of records.

2. Specify values that the checkpoint will verify:

   • To mark the database column for storing and verification, select its check box in the Store column.

   • To mark the database column as a key column, select its check box in the Key column of the page. TestComplete uses key columns to identify records. For more information on how to choose key columns, see Using Key Columns.

     Note:

     The key fields are used to identify records, therefore, the database provider, which is used to access data, should support sorting of records on these fields. To avoid possible problems, we recommend that you select the Key check box for the fields of ordinary types and avoid selecting the check box for non-ordinary fields such as hyperlink or memo.

On the Preview tab of the wizard, you can view the data retrieved from the database.

To save the checkpoint setting and to close the wizard, click Finish.

See Also

Checkpoint Wizard - Configure Database Table Checkpoint
How the Database Verification Procedure Works
Using Key Columns
Creating Database Checkpoints
About Checkpoints
About DBTables Collection