Set SQL Statement Page

Relevant for: API testing only

This wizard page enables you to prepare an SQL statement for retrieving your data.

Wizard map

This wizard contains:

Set Database Connection Page > Set SQL Statement Page

User interface elements are described below (unlabeled elements are shown in angle brackets):

UI Element

Description
Data source name

The name of the data source as it is be referenced by your test. If no value is specified, it uses the name of the table or view.
SQL statement

A drop down list of the available SQL statements.

Opens the Query Builder Dialog Box.
<SQL statement area>

An editable area for pasting existing SQL strings or for editing the SQL string selected in the drop down list.

Tip: To add an SQL statement pasted into the text area to the drop down list, click Check SQL Statement.
Check SQL Statement

Executes the SQL statement shown in the text area and opens the results in a Query Preview window.
<query status>

If the statement is valid, the wizard adds it to the drop down list of SQL statements and changes the status to Query executed successfully.