Softpedia >Windows >Internet >Servers >Database Utils >SQLTools >  Changelog

SQLTools Changelog

What's new in SQLTools 2.0 Build 12

Mar 1, 2021
  • Improvements:
  • The program partially supports Unicode/UTF now. The editor works with European languages w/o any issues but eastern characters are not supported mainly because the Windows monospaced fonts are actually not fixed-width for those code pages. The data grid, on other hand, should handle any texts.
  • New docking window framework:
  • The control panels like "File Panel", "History", "Open Files", "Object Viewer" can be docked more easily,
  • as well as stacked in tabs. Additionally panels can "Auto hide" in the docking mode.
  • The window tab control:
  • Workbook is more functional and nicer than in the version 1.9.
  • The external grep program was replaced with the internal implementation which is faster and more functional.
  • Bug fixes for earlier 2.0 version:
  • Autocmpletion for table columns and procedure fails with the timeout error.
  • Tortoise Git menu does not appear in the file context menu
  • Hanging on attempt to send email

New in SQLTools 1.8 Build 40 (Aug 10, 2017)

  • Bug fixes:
  • DDL reverse engineering incrorrectly handles function-base indexes with quoted columns
  • The program cannot connect to a database that is mount but not open.

New in SQLTools 1.8 Build 38 (Aug 10, 2017)

  • Improvements:
  • Updated the program setup and created a new one that does not require admin rights. The new setup uses a user profile folder (instead of C:Program Files) as a default destination for program files.
  • Work started on help system.
  • Bug fixes:
  • "Find Object" fails with EXCEPTION_ACCESS_VIOLATION when Object Viewer "Use Cache" is ON while session "Object Cache" is OFF

New in SQLTools 1.8 Build 37 (Aug 10, 2017)

  • Improvements:
  • Implemented "Rename / Move" command (internally it calls SaveAs and then deletes the original file)
  • the last choice of "Create Quick Snapshot" on exit is preserved now
  • added two options "Show only name in recent files menu" and "Show only name in recent workspace menu" (Editor / File Manger / History settings)
  • added two options "Show workspace name in the application title bar" and "Show workspace name in the application status bar" (Editor / Workspace settings)
  • Bug fixes:
  • added "ON DELETE SET NULL" for FK reverse-engineering
  • remove an inexistent file from the recent menu is not working in some cases
  • File Save fails if file backup does not succeed. The backup failure can be ignored now.
  • Exit can ignore an modified workspace. "Close Workspace" is called before exit now.
  • Raw error handling on losing connection in the background keep alive procedure

New in SQLTools 1.8 Build 36 (Aug 10, 2017)

  • Improvements:
  • Added the option to retain the focus in the editor on "Find Object" F12
  • Added "Find Selected" [or current word] with the default shortcut Ctrl+F3 & Ctrl+Shift+F3
  • Workspace-related improvements:
  • The active workspace name is included in the application title.
  • The format is "CONNECTION - SQLTools 1.8bXX - {workspace} - [filename]"
  • Added dedicated "Workspace" settings page
  • Added option to delete Autosave snapshot on normal exit (see "Workspace" settings)
  • Implemented support for relative path for files stored in workspaces there is an option in "Workspace" settings)
  • Workspaces and backup snapshots have been separated and use 2 different extensions.
  • Name templates for AS and QS snapshots have been unified besides the case when there is an active workspace the workspace name will be used as a prefix for Autosave snapshot.
  • Processing system shutdown in a proper way
  • The command "Save all" saves the active workspace as well
  • "Open Workspace" calls "Close Workspace" first
  • "Close Workspace" asks to save (cancel is possible) and then closes all documents
  • "Close All Files" calls "Close Workspace" if there is the active workspace
  • Bug fixes:
  • Search / replace history is not preserved correctly if INI file is chosen to keep supplemental settings. Search history is stored in binary format now.
  • flickering on attempt to continue fetching data in the grid after disconnect/connect
  • "Go to active document location" not working on the first attempt if FilePanel was not open before
  • fixed skipped in tooltip "comments" of "Object Viewer"

New in SQLTools 1.8 Build 35 (Aug 10, 2017)

  • Improvements:
  • Simplified internal idle processing in order to reduce CPU usage
  • Added ability to turn on/off Syntax Gutter
  • Bug fixes:
  • mismatch between toolbar images and commands introduced in the previous build
  • quick query/count could not be cancelled

New in SQLTools 1.7 Build 55 (Jan 21, 2016)

  • Improvements:
  • Highlighting all occurrences of selected word
  • Displaying full path in the status bar when an open recent file menu item is selected
  • Changed the way the mouse position is mapped to text postion.
  • The cursor position will always move to the left of the character selected by mouse,
  • previously the closest boundary was choosen.
  • Bug fixes:
  • incorrect highlighting in lines stated with 's'

New in SQLTools 1.7 Build 54 (Jan 21, 2016)

  • Improvements:
  • implemented "Keep (connection) alive period", disabled by default (0 min)
  • added new editor command "Duplicate current line or selection" with default shortcut Ctrl+K,Q
  • Bug fixes:
  • QuickQuery (F11) / QuickQCount (Ctrl+F11) do not work with multiline selection
  • Dbms_output spin control on Session settings page works incorrectly

New in SQLTools 1.7 Build 53 (Aug 10, 2015)

  • Bug fixes:
  • Save File: added FlushViewOfFile & FlushFileBuffers to force Windows to flush data to disk
  • QuickQuery (F11) ignores "NULL representation" setting in Data Grid 2

New in SQLTools 1.7 Build 52 Development (Aug 10, 2015)

  • Other changes:
  • Removed the trailing from copy in tab-delimited mode. Hopefully nobody will complain about that.

New in SQLTools 1.7 Build 51 Development (Jan 28, 2015)

  • Bug fixes:
  • bug fix, explain plan view small navigation/focus issues

New in SQLTools 1.7 Build 50 Development (Jan 28, 2015)

  • Bug fixes:
  • bug fix, ObjectViewer compatibility issue with 10g

New in SQLTools 1.7 Build 49 Development (Jan 28, 2015)

  • Improvements:
  • new explain plan view
  • property view for explain plan view

New in SQLTools 1.7 Build 45 Development (Jan 28, 2015)

  • Improvements:
  • added a sql text to the error reporting
  • Bug fixes:
  • bug fix, DDL reverse engineering compatibility issue with 11.1

New in SQLTools 1.7 Build 42 Development (Jan 28, 2015)

  • Bug fixes:
  • bug fix, "Compile" fails on "Types"/"Type Bodies" from "ObjetsList"

New in SQLTools 1.7 Build 41 Development (Jan 28, 2015)

  • Improvements:
  • added support for dbms_xplan. Taken from sqltools++ but it was altered.
  • added two properties to the Grid setting: "Headers in lowercase"
  • and "Wrap around cursor" (sqltools++)
  • "Count" from ObjectViewer is possible with selected columns as well:
  • select , count(*) from group by order by count(*) desc

New in SQLTools 1.6 Build 24 (May 23, 2014)

  • Bug fixes:
  • Autocomplete for package procedures does not work

New in SQLTools 1.6 Build 23 (May 23, 2014)

  • Improvements:
  • ObjectViewer is finalized,
  • hopefully I will need only to add new stuff as partition/subpartition info
  • Addded "Load DDL with Dbms_Metadata", the shortcut is Alt+F12

New in SQLTools 1.6 Build 21 (May 23, 2014)

  • Improvements:
  • New ObjectViewer look, tree lines have been sacrificed
  • in favor of colunm formatted datatypes
  • Bug fixes:
  • cannot load index DDL form ObjectViewr

New in SQLTools 1.6 Build 20 (May 23, 2014)

  • Improvements: Removed RULE hint from DDL reverse engineering for server versions >= 10g

New in SQLTools 1.6 Build 19 (May 23, 2014)

  • Improvements:
  • Autocomplete (objects, table column / package procedures)
  • Bug fixes:
  • template changes are not available for already open files
  • read-only connection does not allow explain plan
  • commit command is not disabled in read-only mode
  • read-only connection asks about commit/rollback on close

New in SQLTools 1.6 Build 16 (May 23, 2014)

  • Implemented REFCURSOR and DATE bind variables. The last one is not supported by Oracle SQL*PLus

New in SQLTools 1.6 Build 15 (Dec 6, 2013)

  • Bug fixes:
  • Find Brace (Ctrl+[) and brace highlighting cause an exception under some conditions
  • DDL reengineering and Object Viewer show zero column size for RAW type
  • Fixed some typos in messages

New in SQLTools 1.6 Build 14 (Dec 10, 2011)

  • Bug fixes:
  • - brace highlighting is wrong if the context is horizontally scrolled.
  • - define/undefine can be erroneously executed while "Execute Current" is searching for the beginning of the current statement. The substitution variables can be changed as the result.

New in SQLTools 1.6 Build 12 (Dec 10, 2011)

  • Improvements:
  • - Added highlighting for matching brace, two color properties "Highlighting" and "Error Highlighting". Taken from sqltools++ but it was altered.
  • - Two environment variables ORACLE_HOME and TNS_ADMIN were added to "About Dialog" and bug reporting
  • - Table and view columns can be sorted alphabetically. "Object List" gets its own property page in Settings.
  • Bug fixes:
  • - current schema synonyms are not highlighted when current_schema user account

New in SQLTools 1.6 Build 11 (Dec 10, 2011)

  • Improvements:
  • - "Object Viewer" is able to show package/type functions and procedures, parameters for stand alone functions and procedures, "references" tables for tables (the old "referenced tables" node was renamed to "referenced by")
  • - "Object Viewer" behavior was changed slightly. If a found object is a package or type then its specification is automatically displayed (the old implementation wants user to select one of them).
  • - Highlighting for user objects. Objects are selected by the current schema rather then user. Quoted identifiers are not supported.
  • - "Refresh object cache" command was added under "Session" menu.
  • - "Safety" combo box was replaced with "Read Only" checkbox in Connection dialog. "Read Only" toggled item was added under "Session" menu.
  • - "Slow network" checkbox was added in Connection dialog. if this option is checked then "Object List" and "Object cache" are not refreshed automatically on connect.
  • - The program can connect to a database that is mount but not open. The same should apply to ASM instance. The feature was taken from SQLTools++.
  • - Text selection by mouse should be smoother on older computers
  • Bug fixes:
  • - "Object Viewer" is incompatible with Oracle 8.0.X (broken in 1.5 build 21/22)
  • - DDL reengineering returns wrong column size for CHAR types in AL32UTF8 database
  • - DDL reengineering prints Zero for INITIAL, MINEXTENTS, MAXEXTENTS in 11g database
  • - Connection dialog opens too slow if the number of stored connection is above a hundred

New in SQLTools 1.6 Build 11 (Dec 10, 2011)

  • Improvements:
  • - "Object Viewer" is able to show package/type functions and procedures, parameters for stand alone functions and procedures, "references" tables for tables (the old "referenced tables" node was renamed to "referenced by")
  • - "Object Viewer" behavior was changed slightly. If a found object is a package or type then its specification is automatically displayed (the old implementation wants user to select one of them).
  • - Highlighting for user objects. Objects are selected by the current schema rather then user. Quoted identifiers are not supported.
  • - "Refresh object cache" command was added under "Session" menu.
  • - "Safety" combo box was replaced with "Read Only" checkbox in Connection dialog. "Read Only" toggled item was added under "Session" menu.
  • - "Slow network" checkbox was added in Connection dialog. if this option is checked then "Object List" and "Object cache" are not refreshed automatically on connect.
  • - The program can connect to a database that is mount but not open. The same should apply to ASM instance. The feature was taken from SQLTools++.
  • - Text selection by mouse should be smoother on older computers
  • Bug fixes:
  • - "Object Viewer" is incompatible with Oracle 8.0.X (broken in 1.5 build 21/22)
  • - DDL reengineering returns wrong column size for CHAR types in AL32UTF8 database
  • - DDL reengineering prints Zero for INITIAL, MINEXTENTS, MAXEXTENTS in 11g database
  • - Connection dialog opens too slow if the number of stored connection is above a hundred

New in SQLTools 1.6 Build 6 (Dec 10, 2011)

  • Improvements:
  • - "File Manager" has basic integration with Windows context menu that allows access to TortoiseSVN / CVS commands using the application menu
  • - "File Manager" allows to execute/rename/delete files and folders
  • - "File Manager" file type filter is finally implemented
  • - "File Manager" shows file/folder information in tooltips
  • - "File Manager" settings page has been added to control new features

New in SQLTools 1.6 Build 4 (Dec 10, 2011)

  • Improvements:
  • - "Execute Current" is smarter now, you do not need to place the cursor on the first line of a statement before execution. It finds the beginning of the the statement based script syntax rules (statements have to be separated by ';' and '/' for PL/SQL stuff). If you like old TOAD style execution then it is supported too (check "Execute Current Alt"). The new settings page allows change default behavior for these 2 commands.
  • - Bulk execution commands "Execute" and "Execute from "Cursor position" have"Halt Execution On Error" option. That works like in SQLTools++ but it first shows an error and then asks if you want to cancel or continue script execution.
  • - Additionally single statement execution commands can highlight and automatically show the beginning and end of the current statement.
  • - the editor does not have 64K line limitation, now it can handle 2GB lines in theory.
  • - "File Panel" restores the last selected tab when application restarts improved stability of XML settings storage and recovery encrypted connection information.
  • Bug fixes:
  • - file custom.keymap is missing
  • - IOT table has extra PK definition if "No storage for PK,UK" is checked
  • - Find Object F12 does not recognize an object name if it is sql*plus keyword
  • - Load DDL Script Ctrl+F12 throws the exception "Invalid object type" on a synonym that is not longer valid

New in SQLTools 1.5 Build 23 (Dec 10, 2011)

  • Improvements:
  • FilePanel restores the last selected tab when application restarts
  • Bug fixes:
  • file custom.keymap is missing
  • IOT table has extra PK definition if "No storage for PK,UK" is checked
  • Find Object F12 does not recognize an object name if it is sql*plus keyword
  • Load DDL Script Ctrl+F12 throws the exception "Invalid object type" on a synonym that is not longer valid
  • "Object Viewer" is incompatible with Oracle 8.0.X (broken in 1.5 build 21/22)
  • DDL reengineering returns wrong column size for CHAR types in AL32UTF8 database
  • DDL reengineering prints Zero for INITIAL, MINEXTENTS, MAXEXTENTS in 11g database