You are here: Core Reference > Coding > QueryPad > Run your Query in QueryPad

Run your Query in QueryPad

When you have entered or pasted your SQL Query into the SQL Query Entry Pane in QueryPad, you can run it:

QueryPad attempts to execute the query.

If your SQL query does not require any parameters, QueryPad will execute the query. However, if your query requires user-defined parameters, a Parameters dialog box is displayed, prompting you to enter the parameter or parameters:

There is a row for each required parameter, with the first parameter in the query being shown as the uppermost row and numbered 01.

Next to the parameter number is an indication of the type of parameter that QueryPad is expecting, for example, (STRING) means that the QueryPad is expecting a string value.

Example:

The following SQL Query includes two unknown parameters, the Parameter dialog is displayed when it is executed, similar to that shown above.

For each parameter:

When you have defined any required parameters, select the OK button to close the Parameters dialog box and run the SQL query.

When QueryPad executes the query, it will perform one of the following, depending on the RESULTSET status:

For further information on the RESULTSET command, see Define whether QueryPad Displays the Results of your SQL Query.

When QueryPad executes your query, it provides diagnostic information about the query in the Information Pane. For more information on the diagnostics, see Understanding the QueryPad Diagnostics.

Further Information

Value Types: see Data Types in the ClearSCADA Guide to Expressions.


ClearSCADA 2015 R2