Active Query Builder VCL Edition 1.9.1

Active SQL Query Builder is a visual query builder component suite that allows your end-users to build complex SQL queries via an intuitive visual interface.

Completely visual building of complex SQL queries.
The unique features of Active SQL Query Builder such as the ability to build queries with unions and subqueries make it the best solution for professional developers. Each union and sub-query has its own working area where it could be built visually as easy a single query.

MS Access style and SQL Server style visual query building interface.
The interface of Active SQL 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. Active SQL Query Builder allows you to tune all parameters of each single part of a query with the dialog window.

User-friendly interface with drag & drop support.
Working with Active SQL Query Builder you can access each union and subquery in one-touch; complex queries can be navigated easily with the tree pane. Columns pane allows you to define grouping, sorting, and constructing criteria in a simple and direct way.

Powerful means of working with parameters.
One of the most exciting features of Active Query Builder is ability to retrieve various information about parsed query like lists of tables and fields used in the query. Working with parameters in Active Query Builder, you may know their names and data types, and discover to what database objects and fields they are related to.

Working in offline mode, storing metadata in XML files.
In many cases, direct connection to the database is undesirable or even impossible from the point of view of security or performance, for example in the ASP.NET environment. In this case, the most convenient solution would be to work with Active Query Builder in offline mode, loading metadata information from a previously saved XML file.