Previous Topic

Next Topic

Book Contents

Book Index

SQL Query Builder - Results tab

Navigator > Setup > SQL Query Builder > Results tab

See also SQL Query Builder.

Shows the results of the query after the Execute Query button is clicked.

Parameters allow you to enter values for the User to specify when running the report. The dataset can be restricted when you test the query.

Param

A parameter specified in the SQL code, starting with a colon, such as :VariableName.

Value

Enter a valid value for the parameter.

Type

The type of field.

Unknown

The type of data is unknown or cannot be predicted.

String

A string of characters consisting of letters and numbers.

Number

A number.

Date

A date.

Boolean

A True or False condition. Valid values are: True, False, T, F, Yes, No, Y, N.

 

Note: After a query has been executed, you cannot modify the Query Layout tab or the SQL tab until you click the Clear Results (Alt+E) button.