Active Query Builder 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.
» All Active Query Builder news

Tweets

News

Testimonial

With users expecting better and better interfaces to deal with complex data retrieval, Active Query Builder has allowed me to provide a highly professional, robust environment to both novice users and skilled query writers.

Thanks to all the team involved. Please keep up the good work.

Screenshots

Join Types

Automatic Joins Creation
Active Query Builder automatically determines relationships between tables and creates appropriate joins for them.

Different Join Types
Active Query Builder allows to define different join types and various server-specific query options visually.

Unions and Sub-queries

Unions and Sub-Queries
Unions, sub queries and derived tables can be accessed and built visually in Active Query Builder as easy as the main query.

Grouping, Sorting and Criteria
Active Query Builder allows to define grouping, sorting, and constructing criteria in a simple and direct way.


Active Query Builder Screenshots

Social networks

Active Query Builderon Google+