Executing a Query - SQL Assistant

Executing a Query

To execute a query

✔ Do one of the following:

On the toolbar click .

Select Tools > Execute.

From the Query Window, right-click and select Execute.

Press F5.

Results from the query appear in one or more Answerset windows.

When you submit a query the background color of the tab and the part of the query that you executed change to the Query is Running color (default pale orange), and the part that you executed is protected. You will not be able to change this protected text but will be able to edit other parts of the query. The current status is shown on a Query Status Bar that appears at the bottom of the Query window.

If the query contains more than one statement, it is replaced by a log that shows the progress of the query. In this case, a button appears at the far right of the query status bar, below the Query window, that allows you to toggle the display between the log and the query itself.

When a query completes, if the executing tab is the active tab, the background color reverts to its default color. If another tab is active, the background color changes to green to indicate that the query in that tab has ended. In this case the color reverts to its default color when you click on the tab.