Active Query Builder v. 1.6 released

Active Database Software announces today the release of Active Query Builder 1.6, a suite of robust and feature-rich .NET-ready ActiveX and VCL components, which allows your end-users to build complex SQL queries via the intuitive visual interface.

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;
• Ability to build, analyze and modify queries in run-time;
• Rich set of properties and events to control behavior of the component.