Feel free to download and try it. There are no time-limits or other breaks. If you have any difficulties installing or running SQL Assistant please come back to this forum and let us know. When posting problem description make sure to enter the complete error message (if any) and description of steps to reproduce the problem. Any other feedback, including suggestions, comments, etc is also much appreciated.

Last edited by SysOp on Sun Aug 26, 2007 10:48 pm; edited 5 times in total

Sun Nov 26, 2006 3:51 pm

SysOpSite Admin

Joined: 26 Nov 2006Posts: 6608

Build 1.0.46 is now available for download. We have fixed some issues over the weekened.

Mon Dec 04, 2006 8:45 am

SysOpSite Admin

Joined: 26 Nov 2006Posts: 6608

Build 1.0.47 is now available for download.

Here is a list of things fixed in .046 and 0.47
1. Max size for object names increased to 127 chars, max size for column and argument names and types increased to 63 chars
2. Keywords formatting bug fixed. It should now work after typing a keyword then pressing Enter key. Previsouly only worked for space and tab
3. SQLFreeHandleError error fixed in shared connections when a db operation attempted after editor already disconnected from the db
4. Oracle 8i support - ALL_TAB_COLS replaced with ALL_TABL_COLUMNS and ALL_PROCEDURES replaces with ALL_OBJECTS

Tue Dec 05, 2006 10:10 am

SysOpSite Admin

Joined: 26 Nov 2006Posts: 6608

Build 1.0.48 is now available for download.

Here is a list of things changed in .048
1. Improved handling of multiple Oracle homes with multiple Oracle client versions
2. Check for target editor executable file name is not case sensitive anymore, e.g. SQLPLUW.EXE and sqlplusw.exe are treated as the same target
3. In SQL Query Analyzer added handling of busy connections. If you type while a query is being run in the same window, SQL Assist will not popup and will not show errors that connection is busy.
4. Fixed issues related to object name filtering in Oracle
5. Disabled "Invalid hook handle" error message.
6. In SQL Server connections fixed error "SQLFreeHandleError - SQL_INVALID_HANDLE"
7. Minor changes in documentation

Thu Dec 07, 2006 12:51 am

SysOpSite Admin

Joined: 26 Nov 2006Posts: 6608

Build .49 is available immediately. Several things have been addressed there

1. Added support for Oracle 10g Express Edition which has no standard ORACLE_HOME settings
2. Added a number of new keywords for Oracle PL/SQL
3. Fixed issue with Toad hot-keys - "Address violation error..."
4. Semicolon added as a keyword separator so now if, for example, you type "end;" it automatically turns to "END;"

Thu Dec 07, 2006 12:55 pm

SysOpSite Admin

Joined: 26 Nov 2006Posts: 6608

Build .50 is now available for download.

Here is a list of things changed in the latest build
1. New installation will NOT overwrite user-changes in the SQL Assistant settings anymore. On install, old configuration file will be renamed and then current settings will be merged with the new configuration file.
2. Brackets added as keyword separators.
3. Fixed bug with incorrect list filtering after use of Tab and then Backspace key
4. Several other changes affecting SQL Assistant internal working, including password encryption method and other.

Mon Dec 11, 2006 1:18 pm

SysOpSite Admin

Joined: 26 Nov 2006Posts: 6608

Build 0.52 is now available. 3 changes have been made:
1. Modified how column names are pasted into the script. If only one table is referenced in a query and not using alias then column names are pasted as is without fully qualified name (schema, table, column), if table alias is specified then selected column is pasted as alias.column_name
2. Improved parsing of comments; now supporting nested /* -- */ comments
2. Improved parsing of strings; now supporting multi-line strings like
SELECT 'line 1
Line 2
Line 3' FROM .

Wed Dec 13, 2006 2:21 pm

SysOpSite Admin

Joined: 26 Nov 2006Posts: 6608

Build 0.55 is now available. Here is what's new:

1. In SQL Reference we corrected syntax for DECLARE CURSOR for both T-SQL 92 and ANSI SQL syntaxes and made them exclusive; their elements cann ot be mixed anymore.

2. Corrected bug in SQL Reference for T-SQL  when clicking and pasting syntax elements spaces are now inserted between pasted keywords and existing text entered by user.

3. Fixed bug causing crashes in SQL Server editors when typing comma in the FROM clause or after JOIN keyword caused by very long table names with foreign keys referencing the first table in the query

5. New enhancement: subqueries in the FROM clause are now parsed and treated as regular tables, their result-set columns are used in the popup along with regular columns

For example:

Code:

SELECT a.* FROM sysobjects AS a, (SELECT max(id) AS max_id FROM sysobjects) AS b WHERE a.id = b.max_id

The popup appearing after the WHERE, JOIN ON and in other parts of the SELECT will show all columns from sysobjects with alias A as well as max_id from the subquery with alias B, so that both a.id and b.max_id can be pasted using the popup. This works for both SQL Server and Oracle editors.

6. New enhancement: editor/IDE window title now can be used as an additional filter parameter for the registered target. For example, using this parameter you can separate SQL Server Enterprise Manager from other MMC applications. Note: Window title supports optional percent sign as wildcard character for dynamic text. For example, in DB Tools the title of the Editor window is "SQL Editor and Debugger - Connected to [Server Name] As [User Name]" where text after the dash is dynamic. So that the title can be entered as "SQL Editor and Debugger %" without double-quotes.

Tue Dec 19, 2006 12:54 am

SysOpSite Admin

Joined: 26 Nov 2006Posts: 6608

Build 0.56 is now available. Here are the changes:

1. Fixed regression bug that made recent SQL Assistant build to stop working with DB Tools
2. Added handling of Home, End, Page Down/Up and other navigation keys pressed while the SQL Assistant popup is displayed

Wed Dec 20, 2006 10:40 am

SysOpSite Admin

Joined: 26 Nov 2006Posts: 6608

Build 0.57 is now available. Here are the changes:

1. Added Cache Refresh option - use F5 key or right-click menu while popup is visible to force the refresh

2. Improved integration with editor's right-click menus. SQL Assistant submenu now appears in all registered editors using standard Windows methods for displaying the right-click context menu. In editors like SQL*Plus that don't support right-click menus, SQL Assistant displays its own menu. Note: since SSMS doesn't implement standard menus it doesn't work in SSMS. We are searching for a work around to make it also work in SSMS.

3. Added support for using alternative item selection key. It should be now easier for people who are used to run Microsoft tools featuring Intellisense and Tab as the selection key. Which selection key to use, can be configured in SQL Assistant options.

4. Updated product documentation

Tue Dec 26, 2006 9:46 am

SysOpSite Admin

Joined: 26 Nov 2006Posts: 6608

Build 0.60 is now available. Here are the changes in this build and build #0.58 (note that build #0.59 hasn't been released):

2. Support for macro-variables in code snippets. See help file for more info.

3. Fix for Notepad crashing when Notepad is registered as a editing target

4. Added support for hints in T-SQL queries (short syntax notation) . Full syntax notation will be added in future builds

5. In SQL Reference added support for user-typing in placeholders while the SQL command/statement syntax is being built.

Tue Jan 16, 2007 10:06 am

SysOpSite Admin

Joined: 26 Nov 2006Posts: 6608

Build 0.64 is now available. Here is what's new:

1. Added support for GRANT, REVOKE, DENY commands

2. Added support for aliases used in UPDATE queries

3. Added support for ALTER, DROP, and partially TRUNCATE commands.

4. Fixed issue with filtering when schema and table names are the same

5. Fixed issue with typing ON keywords in SQL*Plus

6. Added new macro-variables that can be used in code snippets. Please see docs for details.

-----------------------------
Note that builds .62 and .63 have been internal builds

Wed Jan 24, 2007 10:14 am

SysOpSite Admin

Joined: 26 Nov 2006Posts: 6608

Build 1.0.68 is now available. Builds 0.65, 0.66, and 0.67 are internal builds and they haven't been released to public. In all last 4 builds we have focused on fixing remaining bugs reported during the 2-month beta period. We hope you will like the new version.

Thu Feb 01, 2007 12:32 am

SysOpSite Admin

Joined: 26 Nov 2006Posts: 6608

Build 1.0.70 is now available for download. Please note that build 1.0.69 has been skipped.

Here is what's new in the latest build:
1. Enhancement for SQL Server development environments: SQL Assistant now supports SQL Server running databases with different collations. If you had an issue using an earlier version of SQL Assistant, please make sure to delete SqlAssist.cfg file before installing the new version to the same directory

2. Enhancement for Oracle development environments and editors: Oracle public synonyms are now hidden by default, so they don't clog the list of objects in SQL Assistant popups with hundreds of rarely used names. If you need these synonyms in the list, disable the "hide Oracle synonyms" option in SQL Assistant options (on "SQL Assistance" tab click "Oracle" target, then on the right hand side of the screen click "Options" and then click " " button to expand that section. Change "Hide public synonyms" option value from True to False).

Sun Feb 18, 2007 6:36 pm

SysOpSite Admin

Joined: 26 Nov 2006Posts: 6608

Build 1.0.72 is now available for download. Please note that build 1.0.71 has been skipped.

The latest build addresses "Net init" error received when using SQL Assistant with some versions of SSMS.

Additional notes. We are actively working on the new major version 2 and planning to start public beta program in April. It is still not too late to submit new feature requests. If conditions permit we can get them implemented in version 2 or in the following maintenance releases.