Released: Apr 10, 2025

16.2.2 での更新項目

機能

• Improved Oracle SQL*Plus compatibility. INSERT script lines containing spatial data are now split into multiple lines, each less than 2000 characters long.
• There are two changes to the Container Databases page:
  • Up to this version, the last tab on the CDB page showed the properties of the currently selected Oracle container database. You could not see properties of another CDB before switching the container. This release now shows the properties of all CDBs side by side, making it much easier to compare PDB settings. PDB properties differing from the value of the root container are highlighted.
  • Up to this version, the CDB tablespace tab displayed a checkbox that indicated the tablespace is used in the appropriate CDB. KeepTool now replaces the checkbox with the sum of MBytes used from the CDB.
• Since KeepTool 16.1.0, the tables overview page contains a menu item to create "DDL for PostgreSQL Database". In this version a similar menu item has been introduced for Microsoft SQL Server Database. For the time being, the new feature is tagged as 'experimental'.
• The 'Change column order' dialog is available in the context menu of both Data Content and SQL Query Resultset grids. In this release, the dialog has a couple of changes:
  • The dialog now remembers its size.
  • Required columns are displayed in blue font, primary and unique key columns bold; similar to how columns are displayed in several data grid views.
  • Next to each column, the dialog displays an icon that visualizes the column's data type.
  • The dialog now displays a tooltip window showing the column's data type and column comment, if the 'settings | data content | show active tooltips in grid view' setting is active.
• The 'copy to clipboard' menu item on the tables context menu has been renamed to 'Generate code'. The column selection dialog for the SELECT/INSERT/MERGE statement to be generated now displays data type icons next to the column names.
• KeepTool 16.1.0 introduced a new data grid on the right of the tables | master/detail view. It shows column names and data types for the mouse-over table. This release now also shows column comments. To put more focus on the comments, it is advised to resize the data grid area and give it a little bit more space.
• The Create INSERT/UPDATE/MERGE script dialogs now allow you to define replacement expressions for a choice of columns.
• The 'Show DDL' command for users now prompts you for several options what to be included into the script or excluded. The dialog remembers your choice for the next usage.
• The Hora dialog for selecting table columns is displayed when creating DML statements such as INSERT, UPDATE or MERGE SQL. The lower part of the dialog shows a series of buttons that can be used to check or uncheck several table columns at once. Hora 16.2.2 adds a few more options to check or uncheck multiple columns at once. In total, Hora now offers the following options:
  • Check All Columns, Required Columns, Primary and Unique Key Columns, or Indexed Columns.
  • Disable all columns, columns with default values or columns calculated by trigger logic.
• Reverse DB has a new checkbox option 'Always prefix object names with schema name'. When unchecked (default) the logic applies as before, i.e. schema prefixes are included for objects outside of the current schema only. A similar checkbox "Always include schema prefix in 'Show DDL' command" has been added to Hora's Settings | Behavior page. It affects the Show DDL dialog.
• The font of the data type symbols has been reduced to semi-bold in order to achieve a lighter appearance.
• This release renders vector-based skins faster. That is especially noticeable for the WXI skin.
• The setup installs Wibu CodeMeter runtime version 8.20a. It is strictly recommended to update the CodeMeter runtime, especially on your network license server.