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

May 25, 2011

Active Query Builder Java Edition 1.4 released.

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.

What's new in the Active Query Builder Java Edition version 1.4?

• Behavior changes
  • Automatic alias assignment is made when user adds two or more columns with same name to the query.
    The warning message is shown when muptiple columns with same name appear in sub-queries in result of user actions as this may lead to inconsistence in the calling sub-query.
  • The Select checkbox is checked automatically now on adding a new expression.
  • Grouping is set automatically now on specifying the aggregate for a column now.
  • The numbers entered into condition for string fields are treated as literals.
  • The "=TRUE" condition is set automatically on adding a logical expression now. Useful on adding the EXISTS expressions.
• SQL Syntax changes
  • MS SQL Server: Fetching metadata object descriptions from database is made.
  • MySQL Query Properties form is redesigned.
  • MySQL: The SELECT [DISTICT|ALL] options are added to the query properties dialog.
  • MySQL: Many minor syntax fixes are made.
• API Changes
  • The new UserMessage event is added.
    It is fired when the Query Builder is about to show the warning message to the user. You may override this behavior by handling this event.
  • ObjectMetadataLoading and ObjectMetadataLoaded events were not fired in Offline mode. Fixed now.
  • The new ActiveUnionSubQueryChanged event is added.

Author: Sergey Smagin at ActiveDBSoft.

» All Active Query Builder news

Comments by Disqus: