Other functions
The SQL panel has additional buttons at the bottom:
Link to the online help for the current SQL statement.
A SQL statement is saved in <proj_path>/dplist
. You can use any
file name. The extension for this file must be .txt.
You can select a file containing a query command from the
<proj_path>/dplist
directory. You can open files containing
saved queries from the SQL panel or in a plain text editor (e.g. Notepad); the query is
displayed in the bottom line of the SQL panel and can be launched on the Data tab.
The statements specified on the various tabs are put together into a single query by clicking this button. After opening an existing query it is not necessary to press this button.
Clicking the "Create query" button does not query data from the database. Only pressing "Start query" on the Data tab actually generates the query and displays the results in the window on this tab.
Closes the SQL panel.