There are several editions available:
We recommend you to start from the following guides:
There are numerous demo projects that included in the installation packages to illustrate different aspects of the component's functionality:
The background logo, the hyperlink at the bottom and other ads (nag screen, context menu items, etc.) are present in the Free and Trial versions only. By purchasing the Standard version, you will be free from these elements at all.
The Free version has the Universal Syntax Provider only. This syntax provider is capable to extract metadata from the vast majority of today's popular database servers, but the SQL syntax it is strictly limited to the ANSI SQL/92 standard, thus it can't build or parse specific queries for many database servers.
Programming API limitations deny query structure analysis and programming modifications of SQL queries. Also there is no access to the MetadataContainer object to manipulate with metadata.
Many other advanced features are disabled, such as working in Offline mode (i.e. without live connection to the database), building queries with user-friendly alternate names instead of real database object and field names, etc.
For more information, please visit the Feature Matrix page for specific edition of Active Query Builder:
The Free version of Active Query Builder can be used freely for any purposes, without any fees and royalties.
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.
Grouping, Sorting and Criteria
Active Query Builder allows to define grouping, sorting, and constructing criteria in a simple and direct way.
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.
ActiveX Edition: Numerous Language Demos;
VCL Edition: Main Demo Project.