Active Query Builder is a query builder component suite for Delphi and C++Builder which gives your end-users the ability to create complex SQL queries containing unions and sub-queries via an intuitive visual interface. Active Query Builder has complete support of Oracle, Microsoft SQL Server, MySQL, PostgreSQL, InterBase, Informix and more SQL dialects and can be integrated with your application by setting a few properties or adding a few lines of code.

Overview

Active Query Builder inclides an SQL parser that correctly handles SQL queries containing multiple nested joins and other detailed points of SQL syntax. Another feature is the graphical engine that allows you to build queries involving unions, nested joins and sub-queries.

The interface of Active Query Builder for Delphi is similar to either Microsoft Access or SQL Server visual query construction interface.

Active Query Builder supports Oracle, SQL Server, MySQL, PostgreSQL, InterBase, Firebird, SQLite, and ANSI-92 SQL dialects. The sophisticated Active SQL parser can translate any valid SQL statement into it's visual representation. You can use full range of database connectivity components as well as generic event-driven metadata provider to get metadata information from any data source.

The component may be integrated into a Delphi or C++Builder application with just a few lines of code. 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 a detailed help system and a demo application to help you quickly master the product.

Only for V.I.P