Active Query Builder VCL Edition is a visual query builder component suite that allows your end-users to build SQL queries with unions and subqueries via an intuitive visual interface.
Active Query Builder VCL Edition has a powerful SQL parser that lets you analyze and modify complex SQL queries. Active Query Builder is a true two-way query builder, so that you can combine visual query building with direct SQL query text editing.
Compilation of Active Query Builder with third-party controls will enable you to perfectly match the appearance of the component with the rest of your application. Compilation of Active Query Builder with TNT library will allow you to take advantage of the Unicode-enabled visual query building with any Delphi or C++ Builder IDE version. Please note that this ability is available for the customers of the component with the source code only as far as required for re-compilation with the third-party packages.
We are planning to create metadata providers for all popular database connectivity components but, of course, we cannot cover them all. Thus, we provided for the other ways to load metadata to the query builder from any data source. By using them you can work disconnected, providing all the necessary metadata information by yourself. (You can learn more about the different ways to load metadata at the Load Metadata demo project that is included in the Trial version)
Automatic Joins Creation
Active Query Builder automatically determines relationships between tables and creates appropriate joins for them.
Different Join Types
Active Query Builder allows to define different join types and various server-specific query options visually.
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.
Grouping, Sorting and Criteria
Active Query Builder allows to define grouping, sorting, and constructing criteria in a simple and direct way.