Active Query Builder Free Edition 1.9

Active Query Builder is a query builder component suite that allows your end-users to build complex SQL queries via an intuitive visual interface. It differs from other query builders by its powerful SQL parser that correctly handles SQL queries containing multiple nested joins and other fine points of SQL syntax. Another feature is the powerful graphical engine that allows you to build queries involving unions and sub-queries.

The interface of Active Query Builder is similar to either MS-Access or SQL Server visual query construction interface, but is much more powerful compared to other similar components. The unique features of Active Query Builder for Delphi such as the ability to build queries with unions and subqueries make it the best solution for professional developers.

Active Query Builder is a true two-way query builder, so you may combine visual query building with direct SQL query editing. Changes made to the SQL query text will be affected to the query builder immediately.

Using the Active SQL Query Builder you can customize SQL code the way you like it. There are a lot of properties that can be used to customize the resulting SQL query representation, specifying when to move to the next line, to increase the indent, to wrap a line.

The component may be integrated into your application with just a few lines of code. Unlike many other query building solutions, Active Query Builder does not force the programmer to use the embedded data grid, SQL editor or anything else. Instead, it allows you to integrate any accompanying tools into your application as quickly and easily as possible. The product is shipped with detailed help system and a demo application to help you quickly master the product.

Active Query Builder is available as a Delphi VCL component, as ActiveX control or as Windows.Forms .NET component, so it can be used in almost any software and it is absolutely free, even for commercial purposes!

Requirements: N/A

What's new in this version: The new Universal Syntax Provider is added to the Free version. It is based on the ANSI SQL/92 syntax but allows to determine most of popular database servers, successfully retrieve metadata and apply specific settings for them to let the user build correct queries for these servers.