Active Query Builder

October 22, 2009

Active Query Builder .NET Edition 1.11 released
Support of VistaDB 4 and custom aggregate functions for MS SQL Server, Portuguese (Brazil) translation is added.

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

Active Query Builder .NET Edition 1.10 released.
Support of DevExpress DXperience controls is made, Firebird 2.5 support is added.

August 03, 2009

Active Query Builder VCL and ActiveX Editions 1.13 released
Embarcadero RAD Studio 2010 and Firebird 2.5 are supported now.

June 11, 2009

Active Query Builder Java Edition 1.1 released
Ability to localize the component and to define custom expression builder for the Expression and Criteria columns is made.

May 19, 2009

Active Query Builder VCL and ActiveX Editions 1.12 released
Numerous usability, SQL syntax and API improvements are made.

May 18, 2009

Active Query Builder .NET Edition 1.9 released.
Numerous usability, SQL syntax and API improvements are made.

May 14, 2009

Active Query Builder Java Edition 1.0.5 released.
Numerous demo projects are added to illustrate different aspects of the functionality.

April 21, 2009

Active Query Builder Java Edition 1.0 is out!
The first public version of Active Query Builder Java Edition is released!

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.

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.
CodeGear - Where Developers Matter

Screenshots

Multiple joins

Automatic Joins Creation
Active Query Builder automatically determines relationships between tables and creates appropriate joins for them.

Join Types

Different Join Types
Active Query Builder allows to define different join types and various server-specific query options visually.

Criteria pane

Grouping, Sorting and Criteria
Active Query Builder allows to define grouping, sorting, and constructing criteria in a simple and direct way.

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.


More Screenshots