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

April 24, 2008

Active Query Builder VCL and ActiveX 1.9.1 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.9.1?

  • Common changes
    • Sleep mode is implemented. *
      This mode allows you to suppress error messages while printing unsupported statements in SQL text editor, connected with Active Query Builder.
      Active Query Builder now switches to Sleep mode when non-SELECT statement is passed to the SQL property. This allows your end-users to write any other statements, such as INSERT, UPDATE, DELETE, CREATE ..., ALTER ..., etc., without any additional processing.
    • New properties are added to parenthesize conditions in WHERE clause. *
    • The new boolean QueryBuilder.TreeOptionsMetadata.HideSingleDatabaseNode property is added to hide the database node from metadata objects tree when there is only one database is loaded to the metadata container.
    • The new demo is added to illustrate ability to replace real object and field names with user-friendly alternate names (Demos/AlternateNames).
    • PostgreSQL query properties form is added.
    • Numerous fixes in MySQL, DB2, Sybase and other SQL dialects.
    • Chinese, Italian, German and Portuguese (Brazil) localizations files are updated. Spanish, Czech, Turkish and Japanese localization require updating. Please let us know if you can update one of them.
  • ActiveX Edition
    • The new demo is added to provide various examples of working with Active Query Builder API (Non-Visual Demo).
  • VCL Edition
    • Tne new demo project is added to illustrate ability to modify queries programmatically (Demos/QueryModificationDemo).
    • The new metadata provider is added for the CoreLab Interbase DAC package ( TacCrIbDACMetadataProvider.
    • New properties are added to the TacQueryBuilder.TreeOptionsMetadata to change captions for database object type grouping nodes: TablesNodeName, ViewsNodeName, ProceduresNodeName, SynonymsNodeName :WideString;
    • TMS Unicode controls are supported now (in Standard version with Source code only).
    • The new TacQueryBuilder.OnActiveSubQueryChanged event is added.

* Learn more about Sleep mode and conditions parenthension here:

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