Active Query Builder

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)

» All Active Query Builder news