<< Click to Display Table of Contents >> SQL SELECTION_FILE |
![]() ![]() ![]() |
Specifies the SQL selection file created in Filter window. This statement also executes the request and returns data.
Returned data become the current result set (they are put on the top of the stack).
The name of the returned result set equals the table name (i.e. the name that is shown in the header of the document when it is not opened by the script), unless it is overwritten by SET_TITLE statement.
sql selection_file="myselection.sql"
If the first line of the SQL in the selection file contains the display name then the columns of the SQL must match the columns available in the display. In this case also the legend is downloaded from the server and it is shown in the header of generated table. If the display name is missing (i.e. the SQL was modified in the filter or it was coded by hand) then the legend is not received from the server and the SQL is handled like free SQL. Free SQL statements can be executed only when they are not disabled in INI file.