Active Query Builder is a query builder component suite for Borland Delphi and C++ Builder that gives your end-users the ability to create queries via a visual interface.
The interface of Active Query Builder is similar to either MS-Access or the SQL Server query construction interface. Features of Active Query Builder include building queries with unions and subqueries.
The component may be integrated with a Delphi or C++ Builder application with a few lines of code. Active Query Builder does not force the programmer to use embedded data grid or SQL editor.
There are two editions available: Standard Edition and Free Edition. The Free Edition includes only ANSI-92 SQL dialect while the Standard Edition includes all declared dialects. Additionally, the Free Edition does not contain the output filters for RTF and HTML formats.
Product features include:
- Visual building of SQL queries with unions, subqueries and nested joins
- ANSI-92, SQL Server, Oracle, MySQL and PostgreSQL SQL dialects support
- Constructing joins via drag-drop
- SQL Server style grouping, sorting, and criteria constructing
- BDE, ADO and ZeosDBO database connectivity components and also generic event driven driver
- Text, RTF and HTML export filters
- Help system and a demo application
- Borland Delphi 6, 7, 2005 and C++ Builder 6 support