SQLDBControl 

Release 1.5.00000 

6 Oct 2007 

Feature Additions:

1. Added support for specifying either underscore or Camel Case notation for parameters in existing editor windows.
2. Provided InfoTips for user-defined functions.
3. Added Intellisense support for user-defined scalar functions that are used in select statements.  Intellisense lists containing scalar functions are displayed when “.” Is typed immediately after a valid owner name (e.g. “select dbo.” will result in a list of scalar functions belonging to the user dbo).
4. Added collapsible object type groups when viewing differences.
5. Added functionality that enables users belonging to the db_owner role in the source control database to take ownership of an object that is checked out by another user.  In this context, ownership refers to the user that has an object checked out.  This is useful if a user has an object checked out and is out of the office, thereby preventing other users from editing the object.
6. Provided an “Auto-Add Objects” option that automatically adds any objects that are not in the project whenever the summary list is displayed.

Code Changes:

1. When completing the right hand side of a join statement a list of table aliases are now displayed.
2. Added “on” as an Intellisense item when the letter “o” is typed.
3. Now handling the Enter key to close the window on the Deploy Status screen and Adding New Objects screen. 
4. When a login failure to an existing database occurs whilst displaying Intellisense, a squiggle error indicator is now displayed underneath the corresponding object. 
5. Made several performance enhancements.
6. Made core changes needed for table support.
7. Added support for SQL Server 2008.
8. Changed code that handles Getting Latest Definitions of objects such that a proper status window is now displayed. 
9. Added an Edit Comment button on Object History page. 

Bug Fixes: 

1. Fixed a bug where upon checking in an object, the subsequent refresh would cause the previously selected item in the list to be lost.  
2. Fixed a bug introduced in the previous build that resulted in Intellisense not displaying object names in the WHERE or JOIN clauses when no alias was specified for the corresponding objects.
3. Fixed a bug where clicking on the “Referenced By” list of objects would result in an exception when the connected database was a case-sensitive database.
4. Fixed a bug where typing “group by “ would result in “group by by” being typed out due to the Intellisense completion not working as expected.
5. Fixed a bug where pressing the “@” key whilst the Intellisense list for SET keywords was visible would not correctly display the Intellisense list of variables as expected.
6. Fixed a bug where the Intellisense list inside a function would appear twice if a data type with a length (e.g. varchar(100)) was used.
7. Fixed a bug where pressing F5 (or Execute button) to alter an object (e.g. stored procedure) that resulted in a syntax error would incorrectly lead to “The object has been modified outside of SQLDBcontrol” messages on subsequent attempts to alter the object or check it in.
8. Fixed a bug where an exception would occur whilst adding multiple objects to a project in situations where one of the objects selected already existed in the project.
9. Fixed a bug where creating a new object and executing the create statement, rather than saving it, would result in no object definition being recorded for that first entry in the history table.
10. Fixed a bug where checking in an object could result in no object history being recorded if the object had no changes since it was most recently altered by directly executing the alter statement from within an editor.
11. Fixed a bug where, when viewing differences, the summary list would fail to generate if a row had been previously selected in the summary list.
12. Fixed a bug where double-clicking on the scroll bar area of the messages document in the result panel would cause an exception.
13. Fixed a bug where it was not possible to delete objects that were labelled as “Not on Server” when connected to a case-sensitive database.