Working With the DBTable Element Editor

Applies to TestComplete 15.40, last modified on March 25, 2022

This topic provides information on tasks you can accomplish in the DBTable Element editor:

Including or Excluding Values from the Comparison

When performing a comparison, TestComplete will compare only those values whose check box is selected in the editor.

  • To mark a cell for comparison, select its check box in the editor.

  • To exclude a cell from comparison, clear its check box.

  • To exclude a row, uncheck all the cells in the row.

Changing Data

To edit stored data:

  • Click the desired cell in the editor or select the desired sell and press F2.

  • Type a new value in the ensuing in-place editor.

Note: We do not recommend that you change values in key columns, because TestComplete uses these values to identify rows during comparison. Changing values in key columns may cause the comparison to fail.

To confirm the changes and close the in-place editor, press Enter. To discard the changes, press Esc.

To set an empty value, delete the current value and press Enter. TestComplete will change the column's type to string, set an empty value as the cell’s data and display a message informing you about it. Confirm the changes.

If you specify any other value in the empty cell later, TestComplete will treat the value as a string and compare it by using string comparison operations.

For information on how to edit stored values from tests, see Modifying DBTable Elements.

Reassigning Key Columns

A key is a value or a combination of values that is unique for every row in a table. TestComplete uses key columns to identify rows during comparison.

You set a key column (or a combination of key columns) in the Select Database Table wizard while creating the DBTable element.

The key columns in the DBTable Element editor have the icon in the header.

To reassign key columns:

  • In the DBTable Element editor click Edit.

  • Specify another set of key columns in the ensuing Select Database Table wizard.

Changing Connection Settings

To change the connection settings that the DBTable element will use to get data from the database for comparison:

  • In the DBTable Element editor click Edit.

  • Click the ellipsis button in the Connection edit box of the ensuing Select Database Table wizard.

  • Specify new connection settings.

Saving Changes

To save changes made to the DBTable Element editor, select File > Save from the TestComplete main menu.

To close the editor without saving changes, close the editor’s tab and answer “No” when TestComplete asks you whether to save changes.

See Also

About DBTable Element Editor
About DBTables Collection
Modifying DBTable Elements

Highlight search results