Downloads

Active Query Builder Java Edition History

September 29, 2009

Active Query Builder Java Edition v.1.1.2.1017

- Oracle: Parsing of the SEED keyword is fixed.

September 25, 2009

Active Query Builder Java Edition v.1.1.2.1016

- Fixed crash when clicking at the Aggregate column cell.

September 22, 2009

Active Query Builder Java Edition v.1.1.2.1015

+ The new properties are made to force the query builder to show or omit the AS
  keyword in alias definition. Use the QueryBuilder and PlainTextSQLBuilder 
  get/setAsKeywordInExpressionAlias() and get/setAsKeywordInObjectAlias()
  methods for this purpose.
+ The new events are added to control unchecking of a field from the datasource
  field list: DatasourceFieldRemoving and DatasourceFieldRemoved.
+ Basic support for custom aggregate functions is implemented.
+ MS SQL Server: Custom aggregate functions retrieving is implemented.
+ Oracle, PostgreSQL: Interval literals are supported now.
+ The INNER keyword can be omitted now in join specifications for Firebird and
  MS SQL via the get/setInnerKeywordInLinks() property.
= API changes: MetadataFieldNameList class is renamed to
  MetadataQualifiedNameList.
- CROSS JOIN processing bug is fixed.
- Wrong link context menu coordinantes when the diagram pane is scrolled down
  are fixed.
- MSSQL: Parsing of DatePart and DateName functions is fixed.
- Oracle: Parsing of "CONNECT BY" and "START WITH" clauses sequence is fixed.
- Minor bugfix in metadata filtering is made.
- Bug with duplicating mixed case field names from case sensitive servers is
  fixed.
- MSSQL: Fixed parsing of fields those names match datatype names, like
  "DateTime".

August 06, 2009

Active Query Builder Java Edition v.1.1.1.1014

+ New property is added to allow visual setting of NULLS FIRST/NULLS LAST
  options: getCriteriaListOptions().setShowNullOrderingInSortTypeColumn().
+ Firebird 2.5 support is added.
+ The new setInnerKeywordInLinks() property is added to SQLBuilder and
  QueryBuilder components to suppress the "INNER" keyword in joins.
+ SQL2003 syntax: Support for OVERLAPS expression is added.
- Firebird: Identifiers validity checks is fixed.
- Sybase ASE support is fixed.
- Parsing of highly parenthesized WHERE joins is fixed.
- Right quotation in "Alias" column is made.
- Right interpretation on writing the "='" and "'" strings in condition cell.
- MSSQL: NULLIF function support is fixed.
- PostgreSQL: SIMILAR TO operator support is fixed.
- PostgreSQL: Escaped and unicode string literals support

June 17, 2009

Active Query Builder Java Edition v.1.1.0.1013

- Fixed: "NOT IN", "NOT LIKE" and "NOT BETWEEN" clauses were being split apart.

June 16, 2009

Active Query Builder Java Edition v.1.1.0.1012

- PostgreSQL: bug in parsing of INTO clause is fixed.

June 11, 2009

Active Query Builder Java Edition v.1.1.0.1011

+ Ability to define custom expression builder for the Expression
  and Criteria columns of the Criteria List is made. To activate this option, 
  you should set the getCriteriaListOptions().setUseCustomExpressionBuilder() 
  property and handle the CustomExpressionBuilderEvent event.
  See the "CustomExpressionBuilderDemo" source code sample.

June 01, 2009

Active Query Builder Java Edition v.1.0.10.1010

+ Localization is implemented. See the README.TXT in 'language_files' directory.

May 27, 2009

Active Query Builder Java Edition v.1.0.9.1009

+ The "Insert sub-query" popup menu is added to Expression and Criteria column
  cells.
- The bug with saving of relation child cardinality to XML file is fixed.
- The bug that leaded to exponential grow of parsing time for some FROM clauses
  is fixed.

May 22, 2009

Active Query Builder Java Edition v.1.0.8.1008

- Critical bug in metadata fields loading is fixed.