Benthic Software BenthicSQALL v2.1 Build 34
Benthic Software BenthicSQALL v2.1 Build 34 | 2.8 MB
BenthicSQALL is an SQL query tool that works with any database with an ODBC or OLEDB driver. This includes Oracle, DB2, Sql Server, Sybase, MySQL, Firebird and many others.
- Supported Client Operating systems: Windows 2000, 2003, 2008, XP, Vista, Windows 7, Terminal Server/Citrix
- Supports any database with a 32bit ODBC or OLEDB driver
- Full Unicode support
- Tabbed interface including Workspaces
- Syntax highlighting SQL editor
- Client side sorting and filtering
- Export to Excel and Open Office Calc
- Direct editing of query results (if supported by driver.)
- Data export in multiple formats including CSV and HTML.
- Support for SQL Bind variables.
- Support for prompt variables to make your SQL statements and scripts interactive.
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.