Active Query Builder

August 13, 2009

Active Query Builder .NET Edition 1.10 released.

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

What's new in the Active Query Builder .NET Edition version 1.10?

• General improvements:
  • Support for DevExpress 2009.1 controls is added. To use DevExpress controls, you should add a reference to the ActiveQueryBuilder.DevExpressControlFactory.dll file to your project or you may simply put the .dll near by your executable file. In the Main() function of your application, before any form creation, set up the DevExpress usage and turn on QueryBuilder's static property "UseDevExpressControls":

          DevExpress.Skins.SkinManager.EnableFormSkins();
          QueryBuilder.UseDevExpressControls = true;
    

    Your project also must refer to DevExpress.Data.*, DevExpress.Utils.*, DevExpress.XtraEditors.*, DevExpress.XtraGrid.* and DevExpress.XtraTreeList.* assemblies.
  • Installation package now contains source code of metadata providers that depend on third-party ADO.NET providers. If you need to use some specific ADO.NET library version, you can rebuild a metadata provider with new references without our assistance.
• API improvements:
  • The new property is added to allow visual setting of NULLS FIRST/NULLS LAST options: queryBuilder.CriteriaListOptions.ShowNullOrderingInSortTypeColumn.
  • New property InnerKeywordInLinks is added to SQLBuilder and QueryBuilder components to suppress the "INNER" keyword in joins.
  • The new CriteriaListControlInitialization event is added for additional customization of the grid.
  • TableChecksCountInCaption property is renamed to CheckedFieldsCountInCaption.
• SQL Syntax fixes and improvements:
  • Firebird 2.5 support is added.
  • MS SQL Server: Loading synonyms info for SQL Server 2005 is made.
  • PostgreSQL, DB2, SQL2003: Support of NULLS FIRST and NULLS LAST is added.
  • PostgreSQL: Escaped and unicode string literals support is added.
  • DB2: Support of CONCAT operator is added.
  • SQL2003: Support for OVERLAPS expression is added.
  • Sybase ASE support is fixed.
  • MSSQL: NULLIF function support is fixed.
  • PostgreSQL: SIMILAR TO operator support is fixed.
  • PostgreSQL: The bug in parsing of 'interval' type is fixed.
  • Query builder was not loading the scale of table columns. Fixed now.
  • Fixed the "NOT IN", "NOT LIKE" and "NOT BETWEEN" clauses were being split apart

» All Active Query Builder news