SQLDetective Releases

Released: Mar 31, 2020

Updates in 5.1.1.316

Features

  • Preferences - Removed the “Notify about AMS expiration” check box from the License Key page.
  • Session Navigator - Added all missing fields to the Process tab and the most frequently used ones are now displayed by default.
  • Code Editor - All occurrences of selected text are now highlighted in the Code Editor.

Fixes

Core

  • Fixed the error “Could not initialize taskbar. Error:-2147467263” when running SQLDetective on Windows Server with Citrix.
  • Files in UTF-8 (with no BOM) and UTF-16 are now...

Released: Nov 28, 2019

Updates in 5.1.1.239

Features

  • Database Connection - Added new “Switch to a new connection in the active window” option which is enabled by default. When disabled, starting a new database session does not change the database connection in the active window.

Fixes

SQL Editor

  • Fixed history panel splitter.
  • Splitter positions of the Dataset Manager and SQL History panels are now remembered and restored correctly.
  • The token with leading ampersand in a string literal is now always recognized as a possible substitution...

Released: Oct 25, 2019

Updates in 5.1.1.212

Features

  • Online Support Desk - The process of downloading updates is now indicated on the Windows taskbar.

Fixes

Core

  • The error “ORA-00933: SQL command not properly ended” is no longer raised on a script execution if a DDL statement contains an empty string.
  • The error “FROM clause not found in SQL” no longer occurs on trying to execute a statement with the apostrophe in a q-notation.
  • Fixed the highlighting of a literal if the opening bracket of a q-notation is followed by a break.
  • A single-line...

Released: Oct 17, 2019

Updates in 5.1.1.210

Features

Core

  • Oracle Client is now automatically downloaded and installed if no installation is detected on the PC.

SQL Editor

  • Added the ability to search for text occurrences in the DBMS Output tab.

Compare Databases

  • Improved the comparison of system generated objects.

Rename Object

  • Added the ability to automatically rename tables indexes.
  • Added the ability to rename tables and indexes of another user.

Dataset/Datagrid

  • Focused cells are now always highlighted in datagrids.

Taskbar

  • Applied...

Released: Jul 18, 2019

Updates in 5.1.1.160

Features

Code Explorer

  • By default, the Code Explorer panel is now always open in the SQL Editor and Stored Program Editor.
  • It is now possible to toggle the visibility of the Code Explorer panel for each module separately.
  • The “Code Explorer” page was removed from Preferences.
  • Added the “Toggle Code Explorer” command to the SQL Editor, Stored Program Editor, and Trigger Wizard pop-up menus.

Text Editor

  • When there is no text occurrence of the searched text in the code, the user is no longer...

Released: Jun 27, 2019

Updates in 5.1.1.146

Features

Core

  • Added the ability to execute an external SQL script file after logon. This behavior can be disabled at “Preferences > Session > Execute the file on logon.”
  • Added the ability to change the password of the current user. The command “Change Password” is now available from the Session menu and from the Object Navigator pop-up menu.
  • The startup window is now closed immediately after selecting an action.

Object Navigator

  • Object properties now include general properties from the all...

Released: Jun 13, 2019

Updates in 5.0.1.182

Features

SQL Editor

  • Improved workflow of automatic determination of execution plans.

Database Monitor

  • Queries now run in a sequence, not in parallel threads.

PL/SQL Debugger

  • Added the ability to view global variables.

Fixes

Code Editors

  • The cursor, when moved using the Ctrl+arrow keys combinations, no longer breaks on pointing to the dollar and number signs.

PL/SQL Debugger

  • The error message “Unhandled exception occurred. Debugger will be terminated.” no longer appears after an Oracle exception...

Released: Apr 30, 2019

Updates in 5.0.1.159

Features

Object Navigator

  • Added the ability to customize Ctrl+Click behavior for database objects.
  • Added new options to “Preferences > Code Editor > Ctrl+Click on an object”:
    • Locate it in Object Navigator.
    • Open it in Object Wizard.
    • Open it in Describe Object.

Preferences

  • Increased object name length to 128 characters.

Fixes

Core

  • Fixed fetching of LONG fields and extraction of DDL triggers and views.

Query Dataset

  • The error “Out of system resources” no longer occurs on trying to run...

Released: Apr 18, 2019

Updates in 5.0.1.146

Features

Core

  • SQLDetective can now connect to databases in MOUNT mode.
  • Added the ability to connect to a database using Oracle Wallet.

Database Monitor

  • Added the ability to perform SQL tracing using the DBMS_MONITOR package:
  • The SQL Trace options are now opened in a separate window on enabling SQL Trace.
  • Removed the SQL Trace options from Preferences.

SQL Editor

  • Removed unnecessary synchronization options of the Data and Editor tabs from Preferences.
  • The Data and Editor tabs are now always...

Released: Mar 13, 2019

Updates in 5.0.1.124

Features

Technical Debt - A new metric to calculate an assumed cost of fixing structural imperfections in code.

Core

  • Redesigned the startup window. It is now possible to choose a license type and apply a license key from the startup window.
  • The last active window is now automatically restored at the next application launch.
  • Added the ability to open Release Notes from the Help menu.
  • Structure bounds are now used in all code editors throughout the application.

Call Trees

  • It is now possible to...