Downloads

Active Query Builder Java Edition History

March 26, 2012

Active Query Builder Java Edition v.1.5.5.1111

- DB2: Fixed parsing of AS400-DB2-specific schema-object delimiter ("/").
- PostgreSQL: Since PostgreSQL 9.0 the AS keyword between expression and alias
  became optional.
- MSSQL: Added support for parsing of static method calls of CLR types like
  geometry STGeomFromText.
- MSSQL: Added TYPE to the list of valid identifiers.

March 06, 2012

Active Query Builder Java Edition v.1.5.5.1110

= Performance optimizations are made.
= QueryStatistics.OutputColumns.ColumnName property returns unquoted name now.
- Setting the QuoteAllIdentifiers and ObjectPrefixSkipping properties does not
  clear the query any more.
- Fixed double space character before unary operators.
- Fixed problem with recursive CTE.
- MySQL: Fixed parsing of logical expressions in criteria cells.
- Oracle: Fixed parsing of TABLE function.
- Oracle: Fixed parsing of expressions like "Expression IN Expression".
- Oracle: Removed the NESTED flag from multiline comments.

February 21, 2012

Active Query Builder Java Edition v.1.5.4.1109

+ The new ComponentCreated and ComponentDestroying events notifying about 
  query UI components created and destroying are added.
= Sub-query tab captions display sub-query alias instead of query text now.

February 10, 2012

Active Query Builder Java Edition v.1.5.3.1108

- CTE fields visibility in sub-query in some cases is fixed.
- Workaround for issues of JDBC-ODBC bridge for Microsoft SQL Server ODBC driver
  related to concurrent statements and random ResultSet fields reading is made.

February 06, 2012

Active Query Builder Java Edition v.1.5.3.1107

= Improved loading of stored procedure fields.
= MS SQL Server: Now FOR XML clause can be used in subqueries too.
= Firebird: The new aggregate function LIST, WEEKDAY and YEARDAY keywords in
  EXTRACT function are added.
- Resizing of CTE datasources on hidden tabs on field list changes is fixed.
- The minor issue in parsing of ORDER BY clause of simple queries is fixed.
- MySQL, PostgreSQL: Loading of column precision and scale from server system
  catalogs is fixed.
- MySQL: Parsing of sub-queries in criteria cells is fixed.
- Loading of stored procedure fields is fixed.

January 09, 2012

Active Query Builder Java Edition v.1.5.2.1106

+ The new properties were added for more customizable SQL query text formatting:
  PlainTextSqlBuilder.get/setDynamicIndents(): allows to indent the next item in 
  the list to the same position as the first item;
  PlainTextSqlBuilder.get/setDynamicRightMargin(): instructs the component not
  to take into account leading spaces when counting line lenght to wrap;
  SQLBuilderFromClauseFormat: get/setNewLineBeforeComma(),
  get/setNewLineBeforeJoinExpression();
  SQLBuilderItemListFormat (formats SELECT list, GROUP BY and ORDER BY items):
  get/setNewLineBeforeComma().

December 21, 2011

Active Query Builder Java Edition v.1.5.1.1105

- DB2: The bug with EXISTS clause parsing is fixed.

December 16, 2011

Active Query Builder Java Edition v.1.5.1.1104

+ The new property PlainTextSQLBuilder.get/setTargetQueryPart is added. 
  It allows you to generate the SQL query text not for the whole query, 
  but for active part of the query only. Possible values are the following:
  Query (default): generate SQL text for the whole query;
  SubQuery: generate text for the currently active sub-query tab;
  UnionSubQuery: generate text for the currently active union sub-query.
+ PlainTextSQLBuilder.get/setSQL property become writable to apply changes in
  the currently active query part to the query builder.
+ The new QueryBuilder.get/setFilterTabsByActiveQueryPart property is added. It
  allows to hide the tabs that do not belong to the currently active query part.
  Possible values are the same as for the PlainTextSQLBuilder.TargetQueryPart.

December 05, 2011

Active Query Builder Java Edition v.1.5.0.1103

- The bug with losing the link type during the link place conversion is fixed.

December 02, 2011

Active Query Builder Java Edition v.1.5.0.1102

- The bug with link type switching from context menu is fixed.