Active Query Builder VCL Edition

Visual Delphi Query Builder

Active Query Builder VCL Edition is a visual query builder component suite for Borland Delphi and C++ Builder that allows your end-users to build complex SQL queries with unions and subqueries via an intuitive visual interface.

Active Delphi Query Builder (VCL Edition) supports the following development environments: Borland Delphi 5-7, Borland C++ Builder 5, 6 and BDS 2005-2007.

  • Common product information about Active Query Builder

    • Completely visual building of complex SQL queries.
    • Two-way query building.
    • MS-Access style and SQL Server style interface.
    • User-friendly interface with drag & drop support.
    • Powerful means of working with parameters.
    • Working in offline mode, storing metadata in XML files.
    • Delicate handling of user queries.
    • Restricting access to unwanted objects
    • Designing user-friendly query building environment
    • Sophisticated SQL parser.
    • Oracle, SQL Server, MS Access, MySQL, PostgreSQL, InterBase, Firebird, IBM DB2, Informix, SQLite and ANSI SQL/92, 89 and 2003 dialects support.
    • SQL Formatter.
  • Integration with Delphi or C++ Builder applications is achieved by setting a few properties or adding a few lines of code.

    The component may be integrated into a Delphi or C++ Builder application with just few lines of code. Unlike many other Delphi query building solutions, Active Query Builder for Delphi 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.

  • Full access to internal query representation objects.

    Active Query Builder gives you full control over the SQL query - you can easily navigate it using the internal query builder objects tree that represents all parts of the SQL query. Also you can edit existing queries or create new SQL queries using these objects in run-time.

  • BDE, ADO, dbExpress, IB Express, Zeos and many other database connectivity Delphi components and generic event driven driver.

    We are planning to create metadata providers for all popular database connectivity components but, of course, we cannot cover them all. Thus we created the generic event-driven metadata provider. You can use it to provide metadata information from any data source. It's quite simple and has just a few events to implement. Using the generic event-driven metadata provider you can work disconnected providing all necessary metadata information by yourself.

  • Take a look at the full list of features of Delphi Query Builder (VCL Edition).

Related pages

News

Testimonial

With users expecting better and better interfaces to deal with complex data retrieval, Active Query Builder has allowed me to provide a highly professional, robust environment to both novice users and skilled query writers.

Thanks to all the team involved. Please keep up the good work.
CodeGear - Where Developers Matter

Screenshots

Multiple joins

Multiple joins
Active Query Builder automatically determines relationships between tables and creates appropriate joins for them.

Subqueries

Subqueries
Subqueries are located on separate tabs and can be accessed and built visually as easy as the main query.

Unions

Unions
Unions are managed from within the union panel at the corner of the visual query builder pane. You can build a query containing several unions in a few clicks!


More Screenshots