Active Query Builder is a query creator component suite for Borland Delphi and C++ Builder which gives your end-users the possibility to make complex queries via the intuitive visual interface.


The interface of Active Query Builder is similar to either MS-Access or SQL Server query construction interface, but has much more possibilities than any other similar component. Such unique feaures of Active Query Builder like building queries with unions and subqueries make it the best solution for professinal tasks.

The component may be integrated with Delphi or C++ Builder application with just few lines of code. Unlike many other query building solutions, Active Query Builder does not force the programmer to use embedded data grid, SQL editor or something else.

Instead, it allows to integrate any accompanying functionality as quickly and easy as possible. There are two editions available: Standard Edition and Free Edition. Free Edition includes only ANSI-92 SQL dialect while Standard Edition includes all declared dialects.

Output filters in RTF and HTML formats will not get in the Free Edition too.

Here are some key features of "Active Query Builder Free Edition":

· SQL Server style and MS-Access style query building visual interface;
· Completely visual building of complex SQL queries with unions, subqueries and nested joins;
· ANSI-92, SQL Server, Oracle, MySQL and PostgreSQL SQL dialects support;
· Sophisticated SQL parser that will translate any valid SQL statement into it's visual representation;
· Constructing joins via simple drag-drop method;
· 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;
· Integration with your application by setting a few properties or a few lines of code;
· Detailed help system and a demo application for quicker mastering the product;
· Borland Delphi 6, 7, 2005 and C++ Builder 6 support.


Requirements:

· Borland Delphi 6, 7, 2005 or C++ Builder 6


What's New in This Release:

· New ability is added to work with stored procedures and functions in TacBaseSyntaxProvider.
· TacQueryBuilder: New methods are added to retrieve lists of tables, views and procedures to support server specific rules of retrieval. For example, to retrieve a list of tables for MS SQL Server, 'exec sp_tables' is executed now.
· New OnGetProcedureNames event is added to the TacEventMetadataProvider component.
· Many improvements and bugfixes in the TacBaseSQLBuilder component
· TacQueryBuilder: The new LinkPainterClass public property is added to change link painting style programmatically.