GoldSqall

Version 1.5 Build 128 - February 21, 2024

• Fixed several issues with autocommit off mode.
• Added ability to pin login items to the top of the list.
• Added new COLUMN LOOKUP script command to add dropdown lists to edit fields.
• Added new COLUMN BLOBEDIT script command to add a "file load" button to edit fields that are blobs.
• Several query performance improvements.

Version 1.4 Build 124 - December 28, 2023

• New Tabs main menu which can be sorted alphabetically or by tab position.
• Fixed printing issue with SQL where last line might not print.
• Fixed issue opening directory select window on 64bit version.
• Several improvements to searching and fixed a rare issue searching backwards with the wholeword option.
• Several improvements for high dpi screens.

Version 1.3 Build 122 - November 22, 2023

• Added new "Autocommit" option to logins.
• Changes to transaction handling for new Autocommit mode setting. Note that this relies on your Database transaction handling system.
• Fixes to SQLServer delimiter script handling.
• Fixed a metadata issue with MySQL.
• Fixed an issue where the last line of SQL text might not print.
• ImpExpSqall: Fixed an issue where popup column lists could be taller than the screen width.
• ImpExpSqall: Better error reporting and handling

Version 1.2 Build 120 - April 30, 2023

• New word multi-highlight feature (Off by default. Set in the Editor options.)
• Improved fonts and item spacing in ImpExpSqall.
• Better import and export file encoding handling in ImpExpSqall.
• Fixed an editor issue with non-breaking space characters.
• Fixed an issue where the SQL Formatter could stop working with certain options.
• Improved the SQL Formatter with complex queries.
• Added '-' captioned tab as spacer feature from Golden 7.x
• Several performance improvements.

Version 1.2 Build 118 - Feb 3, 2023

• New Database: Added support for SQLite.
• New feature: Automatically show blobs that contain pdfs, Word, or Excel documents in the native application.
  This option is off by default and controlled by the "Show blob docs in native application" option on the DataGrid options page.
  Double-click the cell or select it and choose "Show cell detail" to view the document.
• Fix to exports with no records.
• Improved error reporting for Oracle, PostgreSQL, Firebird, and SQLite.
• Added -t"tns_admin path" commandline option to set or override TNS_ADMIN (for Oracle only.) Example: -t"C:\Oracle"

Version 1.1 Build 114 - July 6, 2022

• New import/export tool ImpExpSqall included!
• Fix for clearing datagrid custom formats on date columns.
• Fixed decimal(precision,scale) display with some database drivers.
• Fixed login window not saving and restoring current sort order.
• Several improvements to display under Windows 11.

Version 1.1 Build 112 - May 24, 2022

• Improved BOM handling for UTF files.
• Updated editor shortcuts: Ctrl-Delete (delete next word), Shift-Ctrl-Delete (delete to line end)
• Updated editor shortcuts: Ctrl-Backspace (delete previous word), Shift-Ctrl-Backspace (delete to line beginning)
• Fixed a performance issue with replace all.
• Improved query stop/abort handling to show partial results.

Version 1.1 Build 110 - March 27, 2022

• Tab display improvements.
• New improved tab text visibility especially in dark theme mode.
• New tab modified and busy indicators.
• Editor improvements
• New editor quality and performance improvements.
• New modernized selection color and display improvements.
• New change tracker indicators.
• New indent guide indicators.
• New separate bookmarks and line numbers options.
• Improved editor option choices on the view menu.
• Improved editor option choices on the options window.
• Fixes to undo issues with mixed tab characters.
• Theme and visual improvements for Windows 11 support.
• Find and replace improvements with better reporting and less prompting.
• Fixed an issue with Firebird EXECUTE BLOCK statements.
• Fixed truncated Oracle pl/sql error messages.

Version 1.0 Build 108 - June 15, 2021

• Added Show whitespace to editor options.
• Added support for running Explain plan as a command under oracle.
• Find/Replace dialog now remembers settings.
• Many improvements to the popup typing helper.
• Improved ODBC connectstring entry.
• Improved number entry when editing in the datagrid.
• Improvements to in/out parameter handling and the var command.
• Improved parameter datetime format handling including timestamps.
• Improved fractional time rounding.
• Improved ping server advanced option.
• Several fixes to "Filter like current cell."
• Fixed rounding issue with PostgreSQL decimal numbers.
• Fixed issue with Oracle NUMBER types and negative numbers.
• Fixed a memory leak related to bind prompting.
• Fixed some colors in the dark theme.

Version 1.0 Build 106 - April 19, 2021

• New "prompt for bind variables" feature.
• Improved break button response handling.
• Improved performance for large insert scripts.
• Improved log window text.
• Improved caching of lob fields.
• Improved sorting speed of clob fields.
• Improved "Retain data on disconnect" feature. Note that unfetched lobs will be marked as [disc] (disconnected.)
• Improved CSV blob exporting.
• Improved Datagrid autosize for wide columns.
• Improved advanced option "ping server" for all databases.
• Added missing scale information to time and timestamps for PostgreSQL.
• Added new "set transpose on/off" command to switch grid mode.
• Added new "set bindprompting on/off" command to control bind variable prompting.
• Fixed an issue with some ODBC drivers (particularly Access.)
• Fixed TimestampTz types returning in UTC for PostgreSQL.
• Fixed leading string search in the table list.
• Fixed word-wrap on the cell detail window.
• Fixed an issue where Find in grid wouldn't work correctly in tranposed mode.
• Fixed a find/replace issue where characters could be skipped.
• Fixed an issue with "Filter like current cell."
• Fixed incorrect font color on typing popup window.

Version 1.0 Build 104 - February 17, 2021

• Improved the help file with new SSL information for MySQL connections and Alias help content.
• Performance improvements using SQLBuilder with very large schemas.
• Performance improvements when switching to transposed grid mode.
• Performance improvements for autosizing.
• Performance improvement to brace highlighting on huge scripts or scripts with thousands of braces.
• Fixed several issues related to aliases.
• Fixed a key shortcut issue on keyboards that require a control key combo to type '*'
• Fixed an index error showing a scratch window of a transposed grid under certain conditions.
• Fixed several issues with importing login list files from BenthicSQALL and Golden.

Version 1.0 Build 100 - February 1, 2021

• Initial release!
• Native driver support for Oracle, MySQL, PostgreSQL, Firebird and SQLServer.
• OLEDB and ODBC support for any database
• SQL query and script running including database specific commands, stored procedures, etc.
• Bind variable (:bindvar) and prompt variable (&AskMe) support.
• Language copy & paste feature for integration with programming tools. C++, PHP, Object Pascal and more.
• Support for viewing tables, columns, stored procedures, schemas, etc.
• Incredibly fast data grid with support for transposed mode, sorting, custom formatting, filtering and more.
• Cell detail window for multi-line or formatted Text.
• Image viewer cell detail window with support for Jpg, Gif, Png, Bmp, Tif, MultiPage Tif, etc.
• Export data directly to Excel, Calc, CSV, XML or delimited files.
• Export directly to Excel files even if Excel is not installed.
• Script autorun support and full command-line options.