Active Query Builder Java Edition History

July 21, 2010

Active Query Builder Java Edition v.1.2.9.1033

+ 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.

July 06, 2010

Active Query Builder Java Edition v.1.2.8.1030

- DB2: Loading of complex WITH queries is fixed.

May 12, 2010

Active Query Builder Java Edition v.1.2.8.1029

+ FairCom C-Tree SQL server is supported now. Use it with the SQL92SyntaxProvider 
  or the UniversalSyntaxProvider.
- MS Access table fields fetching is fixed.

April 27, 2010

Active Query Builder Java Edition v.1.2.7.1028

- 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.

March 26, 2010

Active Query Builder Java Edition v.1.2.6.1027

+ 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.

March 17, 2010

Active Query Builder Java Edition v.1.2.5.1025

+ 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.

January 11, 2010

Active Query Builder Java Edition v.1.2.4.1024

+ 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.

November 24, 2009

Active Query Builder Java Edition v.1.2.3.1023

+ 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.

November 17, 2009

Active Query Builder Java Edition v.1.2.2.1022

= 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.

November 12, 2009

Active Query Builder Java Edition v.1.2.2.1021

+ 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.