Active Query Builder  »  News  »  Active Query Builder .NET Edition News

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":
            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
at ActiveDBSoft.
» All Active Query Builder .NET Edition 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