Active Query Builder  »  News  »  Active Query Builder VCL and ActiveX Editions News

March 27, 2007

Active Query Builder VCL and ActiveX 1.7.9 released

We're glad to announce the new minor version of Active Query Builder. You can download the newest version from the download page.

What's new in the Active Query Builder version 1.7.9?

  • Localization
    • Chinese, Czech and Italian localizations are added.
  • SQL Parsing Engine
    • Support of synonyms in Oracle is implemented.
    • Join object hints in MS SQL Server are supported now: WITH (nolock, repeatableread, ...).
    • MS SQL ranking and aggregate window functions and Oracle analytic functions are supported now.
    • Sub-queries in WITH clause now have support of field's aliases.
    • More precise erroneous token reporting.
    • Minor fixes in most of supported SQL dialects are made.
  • SQL Text Builder
    • Several bugs are fixed.
    • The new property is added to control format of the ORDER BY clause:
      • VCL Edition: TSQLBuilderSelectFormat.OrderByFormat.NewLineAfterItem
      • ActiveX Edition: ISQLBuilderSelectFormat.OrderByNewLineAfterEachItem
  • Metadata Container
    • New properties are added for fields to be stored in the Metadata Container: Size (Integer), Precision (Integer), PrimaryKey (Boolean), Nullable (Boolean), ReadOnly (Boolean). They are filled according to database structure and can be saved to XML file. *
    • ActiveX Edition: New properties are added for fields to retrieve data type: IMetadataField.DataType, IStatsUsedColumn.DataType, IStatsOutputColumn.DataType. *
  • Miscellaneous
    • The new (missing) properties are implemented to set width of query structure and database object trees:
      • VCL Edition: TreeOptions.TreeWidth
      • ActiveX Edition: TreeOptions.TreeWidth and TreeOptionsMetadata.TreeWidth
    • VCL Edition: AbsoluteDB Metadata Provider is implemented. *
    • Several memory leaks are eliminated.

* - these features will be available in the Standard Edition of Active Query Builder only.

at ActiveDBSoft.
» All Active Query Builder VCL and ActiveX Editions 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