http://www.activequerybuilder.com/history.html?sec=3-4 Active Query Builder Java Edition Release History http://www.activequerybuilder.com/history.html?story=30&sec=3-4 <pre> + Signed version of ActiveQueryBuilder.jar is added. Use it with applets to avoid security warnings and restrictions. = ActiveQueryBuilder.jar now contains no classes in the default package. - Query Builder was unable to load table fields from MSSQL because it supports the cursor holdability on the connection level only. Fixed now. </pre> 07/21/2010 http://www.activequerybuilder.com/history.html?story=29&sec=3-4 <pre> - DB2: Loading of complex WITH queries is fixed. </pre> 07/06/2010 http://www.activequerybuilder.com/history.html?story=28&sec=3-4 <pre> + FairCom C-Tree SQL server is supported now. Use it with the SQL92SyntaxProvider or the UniversalSyntaxProvider. - MS Access table fields fetching is fixed. </pre> 05/12/2010 http://www.activequerybuilder.com/history.html?story=27&sec=3-4 <pre> - Assertion error if using an alias the same as the object name ("SELECT * FROM Orders Orders") is fixed. - Fields with same names but from different tables were identified incorrectly in some cases. Fixed now. - Option that hides global asterisk item "*" does not hide "Table.*" items. Fixed now. </pre> 04/27/2010 http://www.activequerybuilder.com/history.html?story=26&sec=3-4 <pre> + The new context menu item "Add Common Table Expression" is added to the query building area. - Oracle: Server cursor leaks are eliminated. - MS Access: NULL is removed from list of valid identifiers. - Fixed wrong naming for query objects like "table.*" if more than one "table" used in the query. - MySQL: CONVERT function support is improved. - PostgreSQL: Metadata filter is fixed. - MetadataContainer.saveToXMLFile() did not close the file. Fixed now. </pre> 03/26/2010 http://www.activequerybuilder.com/history.html?story=25&sec=3-4 <pre> + French translation is added. + The new source code example "LoadMetadataAsync" is added to demonstrate asynchronous loading of metadata. + MSSQLCESyntaxProvider is implemented to support Microsoft SQL Server Compact Edition. - MS Access: The bug with unsupported FULL OUTER JOIN is fixed. </pre> 03/17/2010 http://www.activequerybuilder.com/history.html?story=24&sec=3-4 <pre> + The new properties are added to the QueryBase class to set up the Union operator programmatically: - get/setUnionOperator(): gets/sets the unifying operator ('Union', 'Except', 'Intersect' etc.); - is/setUnionAllFlag(): gets/sets the 'All' keyword for the operator; - get/setUnionOperatorFull(): gets/sets the full operator string (e.g. 'Union All'). + The new get/setDiagramPaneVisible() property is made to show hide the diagram pane. - The AfterPropertiesDialog event was firing even if the dialog has been canceled. Fixed now. </pre> 01/11/2010 http://www.activequerybuilder.com/history.html?story=23&sec=3-4 <pre> + MS SQL: support for old-style TransactSQL outer joins: "*=" and "*=" operators. (only if ServerVersion < MSSQL2005) + Sybase: support for old-style TransactSQL outer joins: "*=" and "*=" operators. + MS SQL: Constants for SQL Server 2008 are added. </pre> 11/24/2009 http://www.activequerybuilder.com/history.html?story=22&sec=3-4 <pre> = Active Query Builder automatically generates aliases for virtual calculated fields if they have no alias defined. - Firebird: Support of predefined context variables (CURRENT_DATE, CURRENT_TIME, CURRENT_TIMESTAMP) is added. </pre> 11/17/2009 http://www.activequerybuilder.com/history.html?story=21&sec=3-4 <pre> + The new property is/setLoadJoinsFromWhereClause() is added to instruct the Query Builder to not treat expressions like "tbl1.FieldName = tbl2.FieldName" as joins. They will be loaded as generic WHERE clause expressions instead. + The new method getSchemaNames() to retrieve list of database schemas is added to syntax providers. - LayoutSQL now saves SQL without virtual objects expansion. - Virtual objects can have empty aliases. If alias is empty, AQB creates one from the virtual object name. - Metadata relations loading from Sybase ASE is fixed. - DB2: Metadata filtering is fixed. - DiagramObjectDeleting event was not fired when closing a diagram object through its context menu. Fixed now. </pre> 11/12/2009