Active Database Software

Free tool to build SQL queries

Active Query Builder VCL and ActiveX Editions News

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.
May 20, 2011: Active Query Builder VCL and ActiveX Editions 1.17 released.
Minor usability improvements are made, language files are converted to Unicode.
January 22, 2011: Active Query Builder VCL and ActiveX Editions 1.16 released
Visual building of queries with Common Table Expressions (CTE) is possible now.
March 17, 2010: Active Query Builder VCL and ActiveX Editions 1.15 released
Hiding complex expressions and sub-queries behind ordinary fields and saving derived tables as ordinary database objects is possible now.
October 21, 2009: Active Query Builder VCL and ActiveX Editions 1.14 released
Support of custom aggregate functions for MS SQL Server, other fixes and improvements.
August 03, 2009: Active Query Builder VCL and ActiveX Editions 1.13 released
Embarcadero RAD Studio 2010 and Firebird 2.5 are supported now.
May 19, 2009: Active Query Builder VCL and ActiveX Editions 1.12 released
Numerous usability, SQL syntax and API improvements are made.
February 26, 2009: Active Query Builder VCL and ActiveX Editions 1.11 released
Minor usability and syntax improvements, new properties and events to get control over the query building process.

Tweets

Tweets by @activedbsoft

Follow @activedbsoft

News

03/13/2013 Active Query Builder 2 .NET Edition 2.2 is released.
Teradata SQL syntax is made, handling of selection and indentation in the SQL Text Editor is improved.
03/11/2013 Active Query Builder .NET Edition 1.18 is released
Teardata SQL Syntax is added, SQL Text Editor is improved.
03/04/2013 Active Query Builder Java Edition 1.6 is released.
Teradata SQL syntax is made, more customizable SQL query text formatting is possible now.
RSS

» Active Query Builder news
Subscribe

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.

Knowledge Book
Documentation
User's Guide

Screenshots

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, 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