isql Toolbar

From InterBase
Jump to: navigation, search

Go Up to The IBConsole isql Window


The IBConsole SQL Editor toolbar contains the following buttons:

Toolbar Buttons for Executing SQL Statements
Button Description

SqlBtnPrevQueryList.gif

Displays the previous statement that you entered in the input area. This button can be used repeatedly to step through the stack of statements entered during the current interactive SQL session. The accelerator key is W-P. Click the down arrow next to the button to see a list of available statements. Click a statement in the list to display it in the input area. (Same as Query>Previous.)

InteracSQLnext.png

Steps you forward to the next SQL statement after you have used the Previous command to display earlier statements in the stack. The accelerator key is W-N. Click the down arrow next to the button to see a list of available statements. Click a statement in the list to display it in the input area. (Same as Query>Next.)

InteracSQLexecute.png

Executes the current statement or script in the SQL input area. The output is displayed in the SQL output area. The accelerator key is W‑E. (Same as Query>Execute.)

InteracSQLprepare.png

Displays the query plan for the current query in the SQL output area. (Same as Query>Prepare.)

SqlBtnFetchAll.gif

Forces IBConsole to fetch all the rows of a subquery rather than a subset. Rarely needed, because IBConsole fetches the results as you scroll down in the output area. (Same as Query>Fetch All.)

InteracSQLcommit.png

Commits the transaction specified by the SQL statement to the database. (Same as Transactions>Commit.)

InteracSQLrollback.png

Rolls back all database changes since the last commit. (Same as Transactions>Rollback.)

InteracSQLload.png

Loads a script for SQL execution into the SQL input area. (Same as Query>Load Script.)

InteracSQLsave.png

Saves SQL statements entered in the SQL input area to a file. (Same as Query>Save Script.)

InteracSQLfind.png

Finds text in the SQL input area. (Same as Edit>Find.)

SqlBtnWindowList.gif

Displays a list of current open windows. You can display a window by highlighting it in the list and clicking Switch To or by double-clicking the entry. You can also change windows by clicking the down arrow and clicking the window you want from the drop-down list.

InteracSQLprint.png

Prints the contents of the SQL input area.