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

December 26, 2005

Active Query Builder VCL Edition 1.3 and ActiveX Edition 1.2 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 Active Query Builder VCL Edition 1.3?

• Informix SQL dialect is supported now.
• ANSI SQL/89 dialect is supported now.
• New metadata provider for the Luxena Informix Data Access Components is added (www.luxena.com).
• New metadata providers for the MicroOLAP Data Access Components for MySQL and PostgreSQL are added (www.microolap.com).
• Correct handling of case sensitive indentifiers is implemented.
• The interface of the OnGetFields event is changed. This change allows you to pass WideString field names as well as to store case sensitive field names.

           TacGetSQLFieldNamesEvent = procedure(
              Sender: TacBaseMetadataProvider; const ASQL: 
              String; AFields: TacFieldsList) of object;

• TacQueryBuilder, TacSQLBuilderPlainText: The new QuoteAllIdentifiers property is added. Setting them to True you'll get all identifiers in the query quoted.
  The TacQueryBuilder.QuoteAllIdentifiers is responsible for internal Query Builder quotation and the TacSQLBuilderPlainText.QuoteAllIdentifiers is intended to quote identifiers in result SQL code.
• Many bugfixes in Oracle, Firebird and InterBase SQL dialects.
• Minor interface improvements.

What's new in Active Query Builder ActiveX Edition 1.2?

• Informix SQL dialect is supported now.
• Correct handling of case sensitive indentifiers is implemented.
• Many bugfixes in Oracle, Firebird and InterBase SQL dialects.
• The new LoginPrompt property is added to ask for user name and password on connection.
• The LinkStyle property was implemented incorrectly. This bug is fixed.
• Minor interface improvements.

Author: Sergey Smagin at ActiveDBSoft.

» All Active Query Builder news

Comments by Disqus: