Active Query Builder News

February 28, 2013

Active Query Builder VCL and ActiveX Editions 1.20 are 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.20?

  • ActiveX: 64-bit version is made.
  • Greek translation is added.
  • Teradata syntax provider is made.
  • MS SQL Compact Edition syntax provider is made.
  • Double clicking on a datasource column moves focus to the first criteria cell of the newly added criteria item.
  • An algorithm of choosing datasources for links with complex expressions is improved.
  • Conditions like ">= @DT_END AND <= @DT_START" are loaded into one cell now.
  • The "CTE" prefix is added to CTE sub-query tabs to distinguish them from other types of sub-queries.
  • Select item alias is used as subquery tab caption now.
  • The new "Add Union Sub-query" button is added to the Union navigation bar.
  • The new button is added to each datasource to collapse/expand it's field list.
  • The new GridAlternateRowColor property is made to highlight even rows of the grid.
  • The new FieldListOptions.ShowCollapseExpandButton and FieldListOptions.CollapseExpandButtonLocation properties are made to determine visiblilty and location of the collapse/expand button.
» 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+