Top reasons to use Active Query Builder


  • Make your query building tool look professional!

    The interface of Active Query Builder for Delphi is similar to either MS-Access or SQL Server visual query building interface. It supports Windows XP visual themes, and can be finely tuned by setting appearance properties. Moreover, you can configure not only the appearance, but also the output format of the SQL code generated. You can tune a large number of properties that control indents, new lines and more!

  • Provide your users with powerful means of visual query building!

    One of the most powerful features of Active Query Builder is the ability to build queries with unions and subqueries, that makes it the best solution for professional developers. All components of the query including unions, subqueries, tables and joins can be configured using convenient settings dialog windows; its easy-to-understand drag & drop operations will be intuitive to every user.

  • Provide maximum compatibility with your SQL dialect.

    When we claim supporting an SQL dialect, we don't just say that a set of test queries has been compiled successfully. It means that we thoroughly examined this dialect and guarantee that every valid SQL query will be parsed. Moreover, a number of our syntax providers can be configured to support a specific version of a server because sometimes functionality of SQL queries changes dramatically from one version to another. The powerful parsers generating system based on the improved CoCo/R Compiler Generator has proven to be a reliable basis for such flexibility.

  • Work with any data sources, in unbound or in offline mode.

    If you use Active Query Builder, you can easily connect it to a number of data access components. You can use all standard components and most widely used free and commercial components. But you can provide information about data structure from any source using the generic event-driven metadata provider. You can even work disconnected providing all necessary metadata information by yourself.

  • Build, modify and analyze queries in run-time.

    Active Query Builder gives you full control over an SQL query - you can easily navigate it using the internal query builder objects tree that represents all parts of the SQL query. Active Query Builder provides full control over the SQL query: the fields and tables the user selects in a query and the data that gets displayed on the screen. No more parameter problems; Active Query Builder lets you find out not only each parameter’s name but also the names of each table and field that each parameter applies to.

Unlock the full potential of your software with Active Query Builder!

Learn how Active Query Builder can boost sales of your database management or query building software.

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

Automatic Joins Creation
Active Query Builder automatically determines relationships between tables and creates appropriate joins for them.

Join Types

Different Join Types
Active Query Builder allows to define different join types and various server-specific query options visually.

Criteria pane

Grouping, Sorting and Criteria
Active Query Builder allows to define grouping, sorting, and constructing criteria in a simple and direct way.

Unions and Sub-queries

Unions and Sub-Queries
Unions, sub queries and derived tables can be accessed and built visually in Active Query Builder as easy as the main query.


More Screenshots