Active Query Builder Java Edition History

September 25, 2009

Active Query Builder Java Edition v.

- Fixed crash when clicking at the Aggregate column cell.

September 22, 2009

Active Query Builder Java Edition v.

+ 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
- 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
- MSSQL: Fixed parsing of fields those names match datatype names, like

August 06, 2009

Active Query Builder Java Edition v.

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

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

June 16, 2009

Active Query Builder Java Edition v.

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

June 11, 2009

Active Query Builder Java Edition v.

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

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

May 27, 2009

Active Query Builder Java Edition v.

+ The "Insert sub-query" popup menu is added to Expression and Criteria column
- 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.

- Critical bug in metadata fields loading is fixed.

May 21, 2009

Active Query Builder Java Edition v.

+ New source code sample is added to demonstrate creation of Java applet
  to use in the web browser (AppletDemo).
- Bug with loading tables from MySQL 4.1 is fixed.

Product Summary

 Active Query Builder WinForms .NET Edition:

 Active Query Builder WPF .NET Edition:

 Active Query Builder ASP.NET Edition:

 Active Query Builder Java Edition:

 Active Query Builder ActiveX Edition:

 Active Query Builder VCL Edition:



We have been using Active Query Builder for over a year and must say that both the product and support have been outstanding!

We chose Active Query Builder due to its flexibility and features, but have been truly pleased by its power and hidden capabilities. ...

In summary Active Query Builder provides excellent components, great support and a very flexible feature set. It has allowed us to provide features to our end users that I did not think would be possible in the first release of our new tools and in a timeframe that was much shorter than planned. I would recommend that anyone dealing with databases in the .Net world should be aware of this component and its capabilities!

Social networks