Active Query Builder  »  News  »  Active Query Builder Java Edition News

March 18, 2010

Active Query Builder Java Edition 1.2.5

We're glad to announce the new version of Active Query Builder Java Edition. You can download the latest free version or request the trial at the download page.

Major improvements of the new version 1.2.5 are the following:

  • New feature: Virtual database objects and fields.
    It allows to hide complex expressions and sub-queries behind ordinary fields and save derived tables as ordinary database objects. See the "VirtualObjectsAndFields" source code example for demonstration and details.
  • Basic support for custom aggregate functions is implemented.
  • Custom aggregate functions retrieval for MS SQL Server is made.
  • Portuguese (Brazil) and French translations are added.
  • MSSQLCESyntaxProvider is implemented to support Microsoft SQL Server Compact Edition.
  • SQLite: The query properties form is implemented, Ability to fetch metadata from "attached" databases is added.
  • Firebird 2.5 support is added.
  • The new source code example "LoadMetadataAsync" is added to demonstrate asynchronous loading of metadata.
  • The new DiagramObjectDeleting event is added. It notifies you that a user are trying to delete an object from the diagram pane and allows to prevent the deletion.
  • The new events are added to control unchecking of a field from the datasource field list: DatasourceFieldRemoving and DatasourceFieldRemoved.
  • Now it's possible to allow visual setting of NULLS FIRST/NULLS LAST options using the new property: getCriteriaListOptions().setShowNullOrderingInSortTypeColumn().
  • MS SQL Server, Sybase: support for old-style TransactSQL outer joins is made: "*=" and "*=" operators. (only if MS SQL Server version is less than 2005)
at ActiveDBSoft.
» All Active Query Builder news

Comments by Disqus:




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