Intellicus Enterprise Reporting and Business Insights 19.1

Compiling SQL

0 views June 28, 2020 0

When you select the Result tab, the defined SQL statement will be compiled. Record-set is displayed in case of successful completion. If there are errors, they are displayed in the same tab. This would help you in finding the exact location of error(s) and rectify them before using the SQL results in the Layout Designer.

SQL Compilation
Figure 11: SQL Compilation

If the SQL has used a parameter, you will be prompted to provide the values of the parameter.

Viewing SQL Results

The Result tab will display the result based on the SQL statement in the Edit tab. If the SQL statement has used a parameter, you will be prompted to provide the values while viewing the results.

SQL Results
Figure 12: SQL Results