Execute Query Changelog

What's new in Execute Query 4.2.0 Build 5406

Oct 13, 2014
  • Added user preference option to disable row count query on table selection.
  • Fixed export as SQL not respecting column selections for single table exports.
  • Fixed multi-line comment issue when start of each line within the comment
  • contains an asterisk (*).
  • Added ability to maximize and restore the results pane within the editor tab
  • on double-click.
  • Fixed find/replace dialog functionality on replace replacing the next find
  • instead of the current one.
  • Added ability to cancel the query executed within the Data tab on table
  • selection.
  • Removed dependency on agent to set the correct application name for X11.
  • Removed proprietary dependency on sun.misc.BASE64Encoder/Decoder.
  • Added column, constraints and index nodes under table nodes within the Browser
  • tree structure.
  • Improved Query Editor undo/redo support.
  • Improved support for large result set exports.
  • Fixed issue where a driver class name change was not being applied on
  • reconnection with that driver.
  • Moved to Java7 - no longer direct support for Java 6.
  • Modified Execute SQL Script to support progress logging.

New in Execute Query 4.0.0 Build 5297 (Apr 25, 2013)

  • Fixed possible NPE on null catalog value when setting show defaiult cat/schema option only.
  • Added database table data edit support for the browser Data tab where a
  • primary key exists for that table.
  • Modified Query Editor autocomplete to incrementally add to the list instead of waiting to populate the complete list.
  • Modified Query Editor autocomplete to retain derived suggestions list with a new action from te toolbar to force a refresh.
  • Added main connection and driver details panel to scrollpane to avoid
  • field/button collapsing on view resize.
  • Added object count value to all object lists on the Database Browser view.
  • Added summary file info to all export data workers.
  • Added TRACE log level.
  • Modified driver panel class field to use a drop-down box with available
  • drivers in addition to the 'Find' button.
  • Misc UI tweaks for for Mac OS look and feel.
  • Modified to display column names as returned previously defaulted to upper.
  • Fixed applying a column NULL change being executed as NOT NULL from the
  • Database Browser Table view.
  • Modified datbase object node loading to check for a single item only and load contents on selection from the Database Browser.
  • Performance improvements on result set table model.
  • Modified to allow for custom settings directory supplied as an argument on
  • startup using: executequery.user.home.dir=[some_path]
  • Added key event modifiers check for INS key in the Query Editor.

New in Execute Query 3.5.0 Build 5190 (Jul 16, 2012)

  • Fixed issue where saving text and selecting 'All Files' would throw an exception on save.
  • Added support for SELECT...INTO... queries for the Query Editor.
  • Added separate icon for triggers in the database browser.
  • Fixed issue where new or deleted connections were not being updated in the connections table list.
  • Added double-click to size column to fit largest value in query editor.
  • Changed errors in data tab or any object to display on the panel and not use the exception error dialog.
  • Modified detection and execution of create function or procedure statement from the Query Editor to strip out any comments.
  • Added 'Copy Name' popup menu item for all items in the browser tree.
  • Application icons updated.
  • Fixed procedure execution from editor reporting invalid procedure when params have were not loaded by EQ.
  • Added 'Execute as Single Statement' editor action shortcut key.
  • Added database table views to the Query Editor autocomplete list.

New in Execute Query 3.2.1 Build 5146 (May 19, 2010)

  • Minor help doc update.
  • Help menu changes.
  • Added deb package for download.
  • Modified generated queries to use escaped column names where appropriate (ie. in the Query Editor, import/export processes etc).
  • Fixed editor auto-complete popup for less than 2 characters not scrolling to 'starts with' word.
  • Ongoing look and feel tweaks field dimension changes, font changes.
  • Added option to execute queries with comments, whitespace, line-breaks etc as-is. Defaults to executing 'sanitised' queries with comments etc stripped out as has always been the case.
  • Added default insets for UIManager returning null for some look and feels using TabbedPane.tabInsets in determining tab dimensions for scrolling center panel.
  • Modified callable statement generation removing left-hand equals where out parameters do not exist.
  • Fixed issue with data exports for multiple tables where back/next button selection from export file entry would duplicate selected tables in returning to file selection panel.
  • Fixed query execution with trailing semi-colon errors noted with Oracle.
  • Added export result set to file allowing for executing arbitrary SQL SELECT statements and writing the output to a delimited file.
  • Added open and execute SQL script feature allowing for SQL script execution without loading the script in the editor first.