| Version | Change log |
| SQL Data Lens 3.00 Aug 29, 2021 |
V 3.01 (07.11.2021): - ENH : ServerNavigator : Copy connections details for JDBC included; Send connections details for JDBC included - ENH : ServerNavigator : JDBC Connections dialog shows example URLs - ENH : Driver updated to MS SQL Server 9.4.0 (mssql-jdbc-9.4.0.jre11) - ENH : MS SQL Server: Windows authentication fixed V 3.00 (17.10.2021): - Rename: Caché Monitor is now -> SQL Data Lens :-) - ENH : TableViewer : Shows more details for IRIS DB Server - ENH : ServerNavigator : Improved connection testing - ENH : ServerNavigator : Stored Procedures are loaded async - FIXED: ServerNavigator : Expanding node while already connecting doesn't start more tries to connect - ENH : SPViewer : For Stored Procedures SQL Data Lens create CALL scripts based on the Metadata. But SQL Data Lens can also - create a SELECT script for calling a Stored Procedure by using %ODBCIN for each result column - create a SELECT script for calling a Stored Procedure by using %INTERNAL for each result column - create a SELECT script for calling a Stored Procedure by using CAST( col as VARCHAR(255)) for each result column This functions can helb to find and identifiy data type problems within your Stored Procedure - ENH : SQL Editor : Restoring scrollbar position after reload - ENH : SQL Editor : Column completion fixed - ENH : SQL Editor : Hyperlink navigation from connectionname in Statusbar to Server Navigator - ENH : SQL Editor : Refresh grid result is now executed while fetching data - ENH : SQL Editor : Auto Save session state fixed, ordering is restored - ENH : SQL Editor : Improved Syntax highlighting - ENH : SQL Editor : Improved SQL formatter - ENH : Better positioning of dialogs main window - ENH : New Look and Feel Flat Light and Flat Dark integrated from https://github.com/JFormDesigner/FlatLaf - ENH : Improvements for supported dark mode - ENH : Intercell spacing for all table components removed - ENH : SQL DataLens ist shipped with a minimized private JRE (based on JetBrains JDK 11) - ENH : HiDPI support improved. The menu item is removed. The system scale factor is configured on the OS level. Now the per-monitor DPI is supported. Configured as scale factor in Display Settings system dialog (https://blogs.windows.com/windowsdeveloper/2016/10/24/high-dpi-scaling-improvements-for-desktop-applications-and-mixed-mode-dpi-scaling-in-the-windows-10-anniversary-update/#Q70zmTwpp7rCw8gC.97) - ENH : Driver updated to MS SQL Server 9.2.1 (mssql-jdbc-9.2.1.jre11) - ENH : Driver updated to PostgreSQL 42.2.19 (postgresql-42.2.19.jar) (https://jdbc.postgresql.org/download.html) - ENH : Driver updated to H2 Database Engine 1.4.200 (h2-1.4.200.jar) - ENH : Driver updated CsvJdbc - added support to DBF Files - ENH : Driver added for InterSystems IRIS 2021.1 (JDBC Version: 2021.1.0.215) - ENH : "Open in Excel" feature improved - ENH : Export improved: "Save query result to File" ignore read error. So the process doesn't stop and continue on next value |
| SQL Data Lens 2.96 Jul 4, 2020 |
Changes in V 2.96: - ENH : Driver added for InterSystems IRIS 2020.1 (JDBC Version: 2020.1.0.215) - ENH : QueryCloud supports InterSystems IRIS - ENH : QueryCloud show source code of views - ENH : TableViewer : JDBC connections show source code of views (e.g. SQL Server) - ENH : Server Navigator: JDBC connections show source code of views (e.g. SQL Server) - ENH : Native Intersystems IRIS support! - ENH : No installed Java runtime required! Caché Monitor is now shipped with a private JRE (Java Runtime Environmet). |
| SQL Data Lens 2.94 Jan 4, 2020 |
Changes in V 2.94: - ENH : Native Intersystems IRIS support! - ENH : No installed Java runtime required! Caché Monitor is now shipped with a private JRE (Java Runtime Environmet). |
| SQL Data Lens 2.93 Aug 13, 2019 |
Changes in V 2.93: - ENH : Native Intersystems IRIS support added (specific features like GlobalViewer and many more, known from Cache) ------------------------------------------------------------------ - ENH : Show Stored Procedures for JDBC Connecions - ENH : Some refactoring, like removing old startingstopping action for local Caché services - ENH : Server Navigator: Caché CPF Files are available at the management node - ENH : SQL Editor : For Caché & IRIS the PID is in Statusbar - FIXED: SQL Editor : holding the F5 key down (or press SHIFt+ENTER) starts the same statements multiple times, thats fixed now - FIXED: ClassBrowser : many fixes - ENH : Server Navigator: Caché & IRIS Connectino property "Show system objects and namespace" is now splitted in two options: "Show system objects" and "Show system namespaces" - ENH : Driver updated to H2 Database Engine 1.4.199 - ENH : Driver updated to Microsoft JDBC Driver 7.2 for SQL Server (Version: 7.2.2.0) - ENH : Driver updated to InterSystems IRIS JDBC (Version: 2018.2.0.999) - ENH : Driver updated to MySQL 8.0.16 - ENH : Driver updated to SQLlite 3.27.2.1 - ENH : Removed driver for Caché version 2009.1, 2010.1, 2017.1 (2017.2 is still there! ;) - ENH : Server Navigator: columns in tree show now detail information about datatypes, pks and nullable - ENH : TableViewer : More details about global storage per table on the storage tab - ENH : TableViewer : Some smaller ui improvments - ENH : HiDPI font scaling factor reduced - FIXED: Bugfix function "Import Caché & IRIS Connections" - FIXED: Bugfix function "Bulk export wizard" - FIXED: general UI fixes: , e.g. Title handling in main frame - FIXED: disconnect works also on subnodes from ServerConnections - ENH : DateTime UI improvments, e.g. display format is configurable - FIXED: Refresh on Stored Procedure View |
