SQL > SQL dialog > SQL Execution

Executing the SQL statement

Clicking the [Run SQL] button will execute the currently focused SQL statement.

The statement must match the current open database.

One or several SQL statements may be included in the same SQL tab to be executed sequentially.

If the final SQL statement is a SELECT statement, the result will be displayed in the output grid below.

If the statement is a clean single table SELECT, the table can be opened in editable Live Request view enabling you to edit, add/insert and delete records.

If the statement contains manipulated data, JOINs or UNIONs the Live Req. check will be ignored, and the readout will be in read only view.

Refresh and executing SQL statements and scripts

Executing pure SELECT statements or scripts usually allows to be refreshed by the Refresh Button of the Navigator.
However, statements or scripts including any of the commands below:

"CREATE "
"DROP "
"ALTER TABLE "
"INSERT INTO "
"DELETE "
"UPDATE "

will disable (hide) the Refresh Button to prevent inadvertently not only refreshing the display but also re-executing data modifying commands/procedures, as refresh does not only refresh the display but the whole SQL statement/script.

The commands above preventing refresh will also take place if commented to be inactive - however deleting the trailing space(s) will ignore these keywords even if commented.