SQL Data Lens 3.00

"Caché Monitor SQL-Tool für Intersystems Caché"

Was ist neu in dieser Version?: 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