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:
On this page, you can select the needed data storage type.
On this page, you can specify an excel file whose worksheet will be used as a data storage.
On this page, you can define an excel worksheet which will be used as a storage for the needed data.
On this page, you can specify a CVS file (.txt or .cvs) which will be used as a data storage.
On this page, you can define format parameters of the CVS file which will be used as a data storage.
On this page, you can define settings which are used to connect to the needed database.
On this page, you can define the database table that is used as a storage for the needed data.
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.
Variables of the DB Table Type
Add Variable to Keyword Test Wizard