Active Query Builder News

June 26, 2006

Active Query Builder 1.5.5 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.5.5?

  • Active SQL Parser has full Unicode support now.

    Please note that there are several properties to setup charset and other font properties to view your local symbols correctly.
    VCL Edition properties of the TacQueryBuilder component: GridFont, TableFont and TreeFont.
    ActiveX Edition properties of the IActiveQueryBuilderX interface: TablesFont, SelectListFont, StructureTreeFont and ObjectsTreeFont.

  • The new IdentCaseSens property is added to control the behavior of the ANSI SQL syntax provider.

    This property determines whether an identifier should be quoted or not. The necessity to quote identifiers is a subject of naming conventions of specific database server. There are three possible values of this property:

    • icsNonSensitive: all identifiers are considered to be non-case sensitive. I.e. there will be no quoted identifiers except those which have special symbols like spaces. (MS SQL Server, MS Access, FoxPro)
    • icsSensitiveUpper: all identifiers are case sensitive and if an identifier is written with without quotes, it will be considered as ALL-UPPERCASE by the server. (Oracle, Informix, MySQL, InterBase, etc.)
    • icsSensitiveLower: all identifiers are case sensitive and if an identifier is written with without quotes, it will be considered as all-lowercase by the server. (PostgreSQL)

    Please note that this property is effective only for ANSI SQL/89 and SQL/92 standard dialects. For the rest of specific dialects this property is set automatically in accordance with naming conventions of the database server.
    VCL Edition: You may find the IdentCaseSens property at the TacANSI92SyntaxProvider and TacANSI89SyntaxProvider classes.
    ActiveX Edition: IdentCaseSens is the property of the IActiveQueryBuilderX interface.

  • VCL Edition: The new metadata provider for the NexusDB database is added (www.nexusdb.com).*
  • ActiveX Edition: We have made the new dialog that allows you to work with MetadataFilter object. It allows you to filter database objects by their schema and object name. The EditMetadataFilter method will allow you to call this dialog. This method returns True if some of the metadata filtering conditions were changed, so you'll need to refresh metadata to apply these changes.
  • Fixed bug with the Firebird syntax provider.
  • Other minor bugfixes and improvements.

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

» 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+