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. |