KeepTool Professional 16.2.0
Released: Sep 5, 2024
Updates in 16.2.0
Features
- KeepTool now protects your stored database connection passwords from unauthorized access by using AES-256 encryption.
- To create the password store, you will be prompted to enter your new personal master password.
- The next time you start the application, KeepTool will ask you to enter the master password for verification, unless the "Remember password" option has been selected. There is a button on the settings dialog to make KeepTool forget the saved master password.
- Another button allows you to change the master password.
- The password store is part of the file %appdata%\KeepTool16\Projects\KTProjects.XML. This release upgrades the XML file automatically into the new format and keeps a backup copy of the original.
- For security reasons, please consider deleting copies of KTProjects.XML that are belonging to prior KeepTool versions, i.e. version 15 and earlier.
- Added a new menu: item Schema | Purge recycle bin. If you are connected as SYS, the menu item purges the DBA recyclebin, in all other cases the user recyclebin. Emptying the DBA recycle bin can significantly improve SQL performance for Data Dictionary queries on dba_freespace and subsequently on Hora's tablespace overview page, especially for Oracle 19 patch level 18 and later.
- When you create a FastReport from either Data Content or SQL Query resultset, Hora now embeds the SQL query into the report. You can add more embedded detail queries on your own. If you save the report into a FR3 file, all queries are saved within that file.
- For your convenience, both Data Content and SQL Query resultset pages now show:
- Built-in navigator buttons on the record view similar to the overview grid.
- A scrollbar at the bottom of the recordview for record navigation.
- Hora's File|Open menu item now allows you to select multiple files. Each file will be opened on its own tab.
- When using automatic code completion in the SQL editor, Hora 16.1 added automatically a table alias to the table name. In this release, a new 'Table reference' combobox has been added to the 'Automatic Code Completion' section of the Settings | SQL page tab. There is now a choice of 3 options:
- 'by Table Alias' - This implements a logic similar to Hora 16.1. When using automatic code completion within a JOIN clause, Hora automatically suggests a table alias and supports you to continue building up the ON clause using the suggested table alias.
- 'by Table Name' - When using automatic code completion in a JOIN clause, Hora automatically suggests references using the table name rather than an alias.
- 'None' - When using automatic code completion in a JOIN clause, Hora adds the table name only. There is no support for completing the FROM clause any further.
- The integrated editor component has been enabled for per monitor DPI scaling.
- The "create INSERT script" dialog now shows an additional option for bulk INSERT ALL. If the number of records in the dataset is below a given minimum, Hora generates single INSERT statements rather than bulk INSERT ALL.
- Up to version 16.1, Hora queried SQL parameters on the SQL page only for the "execute query" command, i.e. when executing a single SQL query. Hora now introduces parameter substitution for the "execute script" command according to these rules:
- You can initialize SQL parameters using SQL*Plus-like syntax: VAR DEPARTMENT_ID=100.
- Before executing any SQL statement within the script, Hora queries any unknown SQL parameters, i.e. parameter values that have not yet been initialized by either a VAR command, or any previous query for that parameter value within the same script execution.
- For the in-memory grid mode, the formatting of numeric aggregates in the footers of both data content and SQL query resultset grids have been improved.
- The setup now installs Wibu CodeMeter runtime version 8.10b. It is strictly recommended to update the CodeMeter runtime, especially on your network license server.