A Database Query Building Suite by Active Database Software

Active Query Builder is a visual query builder component suite for Borland Delphi 5-7, 2005, C++ Builder 5, 6 and BDS 2006 that allows your end-users to build complex SQL queries via the intuitive visual interface.

It differs from other query builders by its powerful SQL parser that correctly handles SQL queries containing multiple nested joins and other fine points of SQL syntax. Another feature is the powerful graphical engine that allows you to build queries involving unions, nested joins and subqueries.

The interface of Active Query Builder for Delphi is similar to either MS-Access or SQL Server visual query construction interface, but is much more powerful compared to other similar components. The unique features of Active Query Builder for Delphi such as the ability to build queries with unions and subqueries make it the best solution for professional developers.

The component may be integrated into a Delphi or C++ Builder application with just few lines of code. Unlike many other query building solutions for Delphi, Active Query Builder does not force the programmer to use the embedded data grid, SQL editor or anything else. Instead, it allows you to integrate any accompanying tools into your application as quickly and easily as possible.

Active Query Builder gives you full control over the SQL query - you can easily navigate it using the internal query builder objects tree that represents all parts of the SQL query. Also you can edit existing queries or create new SQL queries using these objects in run-time.

Using the Active Query Builder output filters you can transform SQL code into the format you need, customized the way you like it. There are a lot of properties that can be used to customize the resulting SQL query representation, specifying when to move to the next line, to increase the indent, to wrap a line.

Active Query Builder supports Oracle, SQL Server, MS Access, MySQL, PostgreSQL, Informix, Sybase, InterBase, Firebird, SQLite and ANSI SQL/92, SQL/89 dialects (Free Edition includes only ANSI SQL/92 dialect only). Sophisticated Active SQL parser can translate any valid SQL statement into it's visual representation. You can use BDE, ADO, dbExpress, Interbase Express and Zeos database connectivity components and Generic event-driven metadata provider to get metadata information from any data source.

The product is shipped with detailed help system and a demo application for quicker mastering the product.

System Requirements

Borland Delphi 5-7, 2005, 2006 or C++ Builder 6