Active Query Builder  »  News

Active Query Builder VCL and ActiveX Editions News
October 06, 2017

Active Query Builder VCL Edition 1.28 introduces new SQL formatting options.
Formatting of IF and CASE clauses, descriptions in hints of the Metadata Tree, editing parameters of stored procedures and other improvements have been made.

July 21, 2017

Active Query Builder Professional VCL Subscription is available now.
It additionally includes the Advanced SQL Text Editor, SQL Expression Editor and the SQL Filter Builder controls.

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.

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