Active Query Builder  »  News

Active Query Builder VCL and ActiveX Editions News

April 28, 2017

Active Query Builder VCL and ActiveX Editions 1.27 are released.
Support for RAD Studio 10.2 Tokyo has been added, links creation has been improved, Query Transformer is now capable of renaming output query columns.

September 10, 2015

Active Query Builder VCL and ActiveX Editions 1.26 are released.
Support for RAD Studio 10 Seattle is added, Netezza SQL syntax is made.

May 19, 2015

Active Query Builder VCL and ActiveX Editions 1.25 are released.
Support for RAD Studio XE8 is made, re-ordering of query columns made easier by dragging multiple rows in the Query Columns Grid.

September 15, 2014

Active Query Builder VCL and ActiveX Editions 1.24 are released.
Support for RAD Studio XE7 is made, minor improvements and bugfixes are made.

April 24, 2014

Active Query Builder VCL and ActiveX Editions 1.23 are released.
The user can start working with the component almost instantly thanks to asyncronous metadata loading process. Support of RAD Studio XE6 and MS SQL Server 2014 is added.

October 03, 2013

Active Query Builder VCL and ActiveX Editions 1.22 are released.
Support of RAD Studio XE5, ability to browse for linked objects of each datasource and add them to the query with a single click, preservation of layout of datasource objects after parsing of the modified query.

May 29, 2013

Active Query Builder VCL and ActiveX Editions 1.21 are released.
RAD Studio XE4 is supported now, the new QueryTransformer component is added.

February 28, 2013

Active Query Builder VCL and ActiveX Editions 1.20 are released.
Teradata SQL syntax is added, minor UI usability enhancements are made, 64-bit version of ActiveX control is available.

September 12, 2012

Active Query Builder VCL and ActiveX Editions 1.19 are released.
Support of RAD Studio XE3, new properties to customize SQL query text formatting.

December 23, 2011

Active Query Builder VCL and ActiveX Editions 1.18 released.
Ability to show query by parts and to modify sub-query text apart from the main query is made.

News

Tweets

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