Active Query Builder

December 26, 2011

Active Query Builder .NET Edition 1.16 released.
Ability to show query by parts and to modify sub-query text apart from the main query

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

December 19, 2011

Active Query Builder Java Edition 1.5 released.
Ability to show query by parts and to modify sub-query text apart from the main query

May 25, 2011

Active Query Builder Java Edition 1.4 released.
Minor usability improvements and SQL syntax fixes are 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.

May 19, 2011

Active Query Builder .NET Edition 1.15 released.
Fine tuning of the component is made.

March 21, 2011

Active Query Builder ASP.NET Edition 0.5 is released.
Ability to tune the appearance of datasource field lists, documenation and new samples are added.

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.

December 28, 2010

Active Query Builder Java Edition 1.3 released.
Visual building of queries with CTE (Common Table Expressions) is possible now.

December 08, 2010

Active Query Builder ASP.NET Edition 0.4 is released.
The necessary events are added, query properties dialogs are made, localization is possible now.

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