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

March 05, 2008

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

• Common changes
  • The new Universal Syntax Provider is added to the Free version.
    It is based on the ANSI SQL/92 syntax but allows to determine most of popular database servers, successfully retrieve metadata and apply specific settings for them to let the user build simple queries for these servers.
    Please note that this does not mean that the Universal Syntax Provider could be a suitable replacement for specific database syntax providers, as it strictly follows the rules of ANSI standard, that may lead to many incompatibilities while working with specific database servers. Working with the Standard version, use the Auto Syntax Provider in case of necessity to detect database server automatically.
  • ANSI SQL/92 Syntax Provider has been removed from the Free version.
  • Most of the demo projects are modified to work with Universal Syntax Provider by default.
• VCL Edition
  • The new way of loading metadata is added to the Event Metadata Provider.
    The new OnloadObjectMetadata event is added to the TacEventMetadataProvider to replace the OnGetSQLFieldNames event. The new event allows you to provide more information about specific database objects, such as stored procedure parameters, etc.
  • The new LoadMetadata demo is added instead of the EventMP demo to illustrate all possible ways of loading metadata.
  • ODBCExpress connectivity package is added (www.odbcexpress.com). ^*

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

Author: Sergey Smagin at ActiveDBSoft.

» All Active Query Builder news

Comments by Disqus: