Build #48, 12/21/2007

NOTES

This is going to be considered 3.3 release candidate.  It is our policy to not make API changes without a dot release increment.  The WHILE keyword was not implemented, but we wanted to add it. So either we add to add it now, or wait until the 3.4 release.  We decided to add it now, and call this a release candidate to get a little more testing in. 

We are opening this version up to all 3.3 elegible users (meaning anyone who purchased 3.2 in the last 30 days will get it).  We plan to continue to release updates to 3.3 in the coming months, but they will NOT include any API changes.  Fixes, performance enchancements, etc are all ok.  But it is our policy to not change the API unless it is at a dot release to avoid confusion for everyone.  Hopefully we now have the solid base we need in place for 3.3 (for API).

ISSUES AND FIXES

 #279: Keyword restrictions caused changes with existing views - Fixed

#335: Error executing stored proc from code - Correction in user code

#292: Blank value defaults - entering a blank string shows a ''

#342: Key Violations - Fixed

#340: Performance in query - Operation performs 550 ops/sec

#335: Error executing stored proc - Fixed

#327: Importing XML data locks table for... - Resolved

#315: Set multiple variables using SELECT - Resolved

#296: CASE statement fails - Fixed

#193: TSQL Try Catch block handling - Implemented

OTHER NON TICKETED ITEMS

Drag and Drop from the GUI is not currently supported in some binding situations.  We looked and mySQL and other 3rd party databases don't support it either.  It appears that the Microsoft SQL designer uses some undocumented API calls that we cannot get information for how they work.  We will continue to contact Microsoft about this issue and will release an updated 3.3 later.

NEW KEYWORDS:

WHILE - Allows looping in TSQL code

BREAK - Stop the loop before the exit condition

CONTINUE - Stop the current loop and restart at the while operand EXAMPLE:

DECLARE @Count Int;
SET @Count = 0;
WHILE @Count < 100  
BEGIN     
SET @Count = @Count +1        
IF @Count > 10             
BREAK;        
ELSE             
CONTINUE;   
END