BenthicSQALL Update History
Version 2.1 Build 34 - July 11, 2011
. Bind Variable support (See "how to use bind variables" in the help file.)
. Prompt Variable support (See "how to use prompt variables" in the help file.)
. New "Variables" submenu has been added to the Script menu with the following options:
. Edit the Current tab's defined Prompt Variables
. Clear All Prompt Variables in current tab
. Clear All Bind Variables in current tab
. Added the following new Options related to Prompt Variables (set on the Workspaces & Variables tab of Options window).
. Scan for Prompt Variables. Default value is True.
. Scan in comments (only available when "Scan for Prompt Variables" option is checked). Default value is False.
. Hide before/after sql in prompt window (only available when "Scan for Prompt Variables" option is checked). Default value is False.
. Results area now has two panes (selected via Tabs displayed in the status bar)
. The Results tab displays the results grid. The (new) Text tab displays the results of variable display commands.
. A New menu item has been added to the View menu to toggle between the two tabs (Toggle Results/Text Views).
. Tabs can also be toggled with new Hotkey F12.
. Performance improvements to pasting many records at once into the datagrid.
. New "Close Other Tabs" menu item has been added to the context sensitive menu displayed for editor tabs.
. The full filename (including path) will now be displayed when hovering the mouse over a tab.
. Added new "Add Schema Name to Tables" option to the SQL Builder tab of the
Options window. If this option is checked, table names will be prefixed with
the schema name when pasted from the SQL Builder. (Note that this option is only
applicable when a database has more than one schema and the schema information
is returned by the driver). The default value for this option is False/unchecked.
. Bug Fix: SQL statements starting with the "with" command will now properly
display the returned result set
. Bug Fix: SQL select statements that start with an "(" character, for
example: (select * from emp), will now properly display the returned result set.
. Bug Fix: When running scritpts, the editor cursor will now correctly scroll
into view when the script has completed.
. Bug Fix: When pasting text into the script editor, the cursor will now
correctly scroll into view after the paste.
Version 2.0 Build 32 - June, 7, 2010
. Full Unicode support.
. Workspace support.
. Improved Export options.
. Increased Tab options.
. Improvements to the SQLBuilder for many drivers.
. Many small visual and performance improvements.
Version 1.1 Build 12 - April 30, 2009
. Improved: The SQL builder will now display the object type - "Table", "View", "Procedure" or "Function".
. Improved: Export to Excel will work with Excel 2007's higher row and column limits.
Version 1.0 Build 11 - February 28, 2008
. Fixed: When the database driver reports that a field is a "memo" the text will be displayed in the grid.
Version 1.0 Build 10 - November 1, 2007