As you execute SQL statements in the SQL Commander, DbVisualizer saves them as History entries, along with information about the Connection, Catalog, Schema and the execution result. This makes it easy to locate statements and scripts you have executed in the past.
|Table of Contents|
Using Previous and Next in the SQL Commander
If you just want to go back and forth between statements you have executed recently, you can use the Get Previous from History and Get Next from History toolbar buttons in the SQL Commander.
Using the SQL History Window
To look through all saved statements, you can display the History entries by clicking the SQL History toolbar button in the main window or select the corresponding operation from the Tools menu.
In the Tool Properties dialog, in the SQL History category under the General tab, you can specify that sequential executions of the same SQL statement/script should be collected into a single history entry. When this feature is enabled, the Count field number is increased for each execution. In the same Tool Properties category you can also specify rules for when not to create a history entry.
Reusing a History Entry
When you have found the entry you're looking for, you can open it in an SQL Commander by double-clicking it or clicking the corresponding toolbar button.
You can also add the content of an entry to the current content of an SQL Editor. Select the entry in the list, drag it with the mouse key depressed to the position in the editor where you want to add it, and drop it there by releasing the mouse button.
If you realize that you need easy access to a History entry in the future, you can save it is as a Bookmark or other file. Just select the entry and use the Save As operation, or just drag it to the Bookmarks tree and drop it.
You can also locate the file holding the history entry in the file system using the the Open Enclosing Directory right-mouse menu entry or toolbar button. This opens a file chooser for the directory holding the file.
Using Quick Load