KeepTool 7.2.0
19 Mar 2007
- Enhancements to Connect Dialog
- Passwords can be stored in encrypted form
- Connections can be displayed grouped by user or server. Connections can also be sorted in reverse chronological order
- Remarks about connections can be entered and saved using the “Short Description” field
- SQL Page
- The SQL Repository is now known as the ‘Scratchpad’
- The File Explorer, which previously allowed navigation among SQL and PL/SQL files only, now displays all files
- Hora’s integrated editor now displays ASCII files with syntax highlighting and code folding for the most common languages (SQL, PL/SQL, Java, C++, Pascal, HTML, XML, etc.)
- Elementary lexers for TXT, LOG, as well as .sk, .ksh, .csh
- A binary file, such as a Word document, can be opened directly from the File Explorer with the related application
- File Explorer returns to the last displayed directory for each connection
- Statement detection on the SQL code window
- New File Explorer navigation buttons on the SQL page
- Files can be dragged and dropped from Windows Explorer to File Explorer
- A Print Preview window appears before files are printed
- Schema page | Invalid Objects tab
- The context menu contains two new entries: “Compile All Invalid” and “Show DDL”
- Multiple selection is available using the Ctrl key
- PL/SQL Objects page (formerly Packages)”
- The former Packages page is now known as “PL/SQL Objects”
- Triggers can now be displayed on the PL/SQL page, in addition to the Tables page
- The PL/SQL Objects Overview page now contains an additional group, “PL/SQL Debug”
- Performance improvements to the DB Object Browser
- On the Data Contents page, columns with the NOT NULL attribute are highlighted by underlining the column heading
- The context menu on the User Page now makes available the PASSWORD EXPIRE clause of ALTER USER
- New display of the Tables Overview in Data Contents Browser and Query Builder through use of high-performance grid components
- When SQL Recording is in effect, only successfully executed SQL statements are now saved
- Help is now context-sensitive for each page
- The Execution Plan now provides more information. A number of new columns have been added (including Options, Optimizer, Position, Cost, etc.)
- PL/SQL Debugger
- Source code can now be selected via the menu, providing the Debugger has run for at least one step. After the source code is selected, breakpoints can immediately be set
- Context-sensitive graying of buttons and menus has been improved
- The Debugger now automatically provides the Evaluate/Modify function for variables through a tooltipVarious bugs corrected
- In ER Diagrammer, the hints for connections between tables have been moved further from the connecting lines to facilitate working with the lines
- Line breaks and spaces in SQL Editor are ignored when a selected SQL statement is being executed.
- New Import/Export Wizard dialogs that allow saving and loading of user-specific profiles via the Specifications button.
- When printing, paper size defaults to either A4 or Letter depending on regional settings.
- The “Optimizer Mode” combo box under Extras | Settings | Session has been redesigned. The FIRST_ROWS and ALL_ROWS options are no longer available. The field can be edited so that combinations of options are possible.
- A new “PL/SQL Warnings” check box is available under Extras | Settings | Session. This enables PL/SQL warnings to be enabled or disabled for 10g databases. – Hora no longer shows package names in red on the Overview page when only warnings have been generated. They will not be shown in red unless there are actual errors.
- Hora automatically requires a new password when a user’s password has expired.
- The Connect dialog has been made larger in size.
- Hora issues a warning when the oci.dll file predates the database.
- If no file has been selected on the SQL Page’s File Explorer, the editor becomes read-only and has a gray background.
- Improvements to the “Best Fit Columns” function:
- Double-clicking the border between two columns enables Best Fit for the column to the left. This is also true for groups of columns.
- Best Fit Columns” can be automatically put into effect for a certain number of columns or groups, using a new option in Extras | Settings | Behavior.
- Using the check box in the filter panel below the data grid, you can temporarily disable the filter.
- The Tables and PL/SQL page now offer an “Include Synonyms” check box in the upper right corner. The Synonyms tab has been removed from the Tables page.
- Hidden files (those whose name begins with a period) can optionally be made visible or hidden in SQL Scratchpad’s File Explorer. The check box to set this option can be found under Extras > Settings > SQL Page > Hide period-prefixed files.
- The SQL Page now offers the ability to execute a single SQL statement with Ctrl + E when the cursor is placed on it.
- Alphabetic sorting in SQL Scratchpad has been corrected.
- Improved performance when switching between tasks.