Published 05. September 2024
Stored database connection passwords are now protected using AES-256 encryption.
On first use, you’ll be prompted to set a personal master password to create the secure password store.
On application startup, KeepTool will ask for this master password unless “Remember password” is enabled.
New controls in the Settings dialog:
Forget master password (clear saved password).
Change master password (define a new one).
⚠️ Important: Always keep a copy of your master password in a safe place. You will need it to unlock the password store on another machine.
Technical details:
The password store is part of %appdata%\KeepTool16\Projects\KTProjects.XML.
KeepTool 16.2 automatically upgrades this file into the new format and creates a backup of the original.
For security reasons, consider deleting older copies of KTProjects.XML from previous KeepTool versions (v15 and earlier).
New menu item Schema | Purge Recycle Bin:
Connected as SYS → purges the DBA recyclebin.
Connected as any other user → purges the user recyclebin.
Emptying the DBA recycle bin can significantly improve SQL performance on dictionary queries (such as dba_freespace), which directly speeds up Hora’s Tablespace Overview page—especially for Oracle 19 patch level 18 and higher.
When creating a FastReport from Data Content or SQL Query Resultset:
The SQL query is now embedded in the report.
You can add additional detail queries as needed.
When saving a report as an FR3 file, all queries are stored within the file for portability.
Both Data Content and SQL Query Resultset record views now include:
Navigator buttons for record navigation,
Horizontal scrollbar at the bottom for easier browsing.
File | Open now supports selecting multiple files—each opens in its own tab.
In version 16.1.0, automatic code completion always added a table alias.
In 16.2.0, a new “Table reference” combobox has been added to Settings | SQL:
By Table Alias → Suggests aliases in JOIN clauses and assists building ON clauses (as in 16.1.0).
By Table Name → Suggests references using full table names instead of aliases.
None → Inserts only the table name, without completion of the FROM clause (similar to 16.0.0 and earlier).
The integrated editor component now supports per-monitor DPI scaling, ensuring optimal rendering across high-resolution, multi-monitor setups.
Create INSERT Script dialog now includes an option for bulk INSERT ALL:
If the dataset contains fewer than a defined minimum number of records, Hora will instead generate individual INSERT statements.
Until version 16.1, SQL parameters were queried only for “Execute Query” (single statements).
Hora 16.2 now supports parameter substitution in “Execute Script” mode:
Parameters can be initialized using SQL*Plus-like syntax:
VAR DEPARTMENT_ID=100
If a parameter value has not yet been initialized (via VAR or earlier queries in the same script), Hora will prompt for the value before execution.
In in-memory grid mode, formatting of numeric aggregates in the footers of both Data Content and SQL Query Resultset grids has been improved for better readability.
The setup now installs Wibu CodeMeter Runtime version 8.10b.
It is strongly recommended to update the runtime, especially on network license servers.
Download: Wibu User Software Downloads
For details, see the Wibu Security Advisories.