Active Query Builder Free Edition 1.13

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 builder 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 component. 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.

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.

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.

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

SQL Query Building Capabilities to Your Applications with a Few Lines of Code

, Russia (August 1, 2006) - Active Database Software, a provider of solutions for professional database developers, announces today the release of Active Query Builder 1. , a suite of robust and feature-rich . -ready ActiveX and VCL components, which allows your end-users to build complex SQL queries via the intuitive visual interface.

use Active Query Builder Component?
" have been improving our component every day since it has been released, and as a result it became generally recognized among software developers all over the world, " says Sergey Smagin, Product Manager at Active Database Software. " , Active Query Builder is a dynamically growing project with unique features. The product saves much time and development efforts when implementing SQL query building capabilities. It allows developers to increase the range of potential users of their software by simplifying data retrieval process for novice users and helping professionals to build complex SQL queries in a few clicks. As distinct from other products, Active Query Builder provides a great level of flexibility and allows fine-tuning of most of the features. There is a powerful parser that correctly handles complex SQL queries for a number of SQL dialects. Another feature is a powerful graphical engine that allows you to visually build queries involving unions, nested joins and sub-queries. "

Query Builder Component at a Glance
Query Builder combines powerful means of SQL query building with unmatched ease of use. It is shipped under a per-developer license that grants you royalty-free rights to distribute your applications. The component can be used to build applications in Visual Studio and Visual Studio. as well as in Borland Delphi and C++ Builder, it works in Windows Forms and ASP. based applications, developed in many programming languages, including C# and VB. . Along with " -have" features, the components provide you with unique features to help you add even the most sophisticated functionality into your application quickly and easily.

Active Query Builder features:
- Full support for Microsoft SQL Server, Oracle, MySQL, PostgreSQL, InterBase, Firebird, MS Access and many other SQL dialects;
- Powerful SQL parser that correctly handles SQL queries containing correlated sub-queries, multiple nested joins and other fine points of SQL syntax;
- Visual building of queries with unions and sub-queries;
- Building SQL queries with objects from several databases;
- Metadata pre-filtration, fine tuning of metadata information used to build queries;
- Working in Offline mode using metadata information saved in an XML file;
- Flexible SQL builder to format resulting SQL code the way you like it;
- Fine parsing of SQL queries with parameters, retrieving list of parameters;
- Support for Unicode strings;
- Full internationalization support;
- Ability to build, analyze and modify queries in run-time;
- Rich set of properties and events to control behavior of the component.