On the Specify Query page, you can specify a query to a database. After that, TestComplete will obtain the result of this query and will store it to the DB table variable that you are adding to your test.
The Specify Query page is displayed after you choose the Database query data source on the Specify Datasource Type page, and then specify the needed connection settings on the Specify Database Connection Settings page.
On this page, you can specify the needed SQL code for the query. You can enter text into the edit box shown on the page. You can also press Design Query and build the query in the ensuing SQL Designer.
After you have specified the needed query, click Finish to add the specified DB table variable to your keyword test. Back will return you to the previous page of the wizard. Cancel will close the wizard and abort adding the variable.
After adding the new DB table variable, you can use its value in other keyword test operations. For example, you can create data loops storing the current value of a database or a file to the DB table variable and using these values in cycles. To learn more about creating data loops in keyword tests, see the reference of the Data-Driven Loop operation.