Applies to TestComplete 14.50, last modified on August 05, 2020

The Add DB Table Variable wizard assists you with adding DB table variables to your keyword test.

The wizard is called when you select the DB Table value in the Type drop-down list of the Add Variable to Keyword Test or Add Variable wizard and click Next.

The wizard contains the following pages:

Specify Datasource Type Page (DB Table Variable Wizards)

On this page, you can select the needed data storage type.

Specify Excel Workbook Page (DB Table Variable Wizards)

On this page, you can specify an excel file whose worksheet will be used as a data storage.

Select Excel Worksheet Page (DB Table Variable Wizards)

On this page, you can define an excel worksheet which will be used as a storage for the needed data.

Select CSV File Page (DB Table Variable Wizards)

On this page, you can specify a CVS file (.txt or .cvs) which will be used as a data storage.

CSV Format Parameters Page (DB Table Variable Wizards)

On this page, you can define format parameters of the CVS file which will be used as a data storage.

Specify Database Connection Settings Page (DB Table Variable Wizards)

On this page, you can define settings which are used to connect to the needed database.

Select Database Table Page (DB Table Variable Wizards)

On this page, you can define the database table that is used as a storage for the needed data.

Specify Query Page (DB Table Variable Wizards)

On this page, you can specify the query to be used to retrieve data from the database.

After you add a new DB table variable, it is displayed in the Variables page of the Keyword Test editor. You can use its value in other keyword test operations. For example, you can create data loops that store the current value of a database or file to the DB table variable and use these values in cycles. To learn more about creating data loops in keyword tests, see the reference of the Data-Driven Loop operation.

See Also

Variables of the DB Table Type
Add Variable to Keyword Test Wizard

Highlight search results