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 SQL queries with unions and subqueries via an intuitive visual interface. Active Query Builder is also a powerful SQL parser that allows programmatic analysis and modification of complex SQL queries.

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

• Common product information about Active Query Builder
  
  • Easy visual building of complex SQL queries with unions and sub-queries.
  • MS-Access style user-friendly interface with drag & drop support.
  • Two-way SQL query building (combined with SQL text editing).
  • Defining user-friendly aliases for tables and field names.
  • Powerful means of SQL query analysis and programming modification.
  • Working in offline mode, storing metadata in XML files.
  • Restricting access to unwanted objects, preventing query execution.
  • Sophisticated SQL parser, support of most popular database servers.
  • SQL query text formatting.
  • Ability to localize the component.
• Powerful SQL parser with full access to internal query representation objects.

  Active Query Builder gives you full control over the SQL query - you can easily parse SQL queries and navigate them using the internal query builder objects tree that represents all parts of the SQL query. You can edit existing queries or create new SQL queries using these objects in run-time. (See the Non-visual and Query Modification demo projects that included in the Trial version)

• 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.

• Ability to compile the component with DevExpress VCL controls or with Unicode-enabled visual controls from TNT Library

  Compliation of Active Query Builder with the third-party controls will allow you to perfectly match the appearance of the component with the rest of your application. Compilation of Active Query Builder with TNT library will allow you to take advantage of the Unicode-enabled visual query building with any Delphi or C++ Builder IDE version. Please note that this ability is available for the customers of the component with Source code only as far as require re-compilation with the third-party packages.

• BDE, ADO, dbExpress, IB Express, Zeos and many other database connectivity Delphi components and custom metadata providers.

  We are planning to create metadata providers for all popular database connectivity components but, of course, we cannot cover them all. Thus we provided the other ways to load metadata to the query builder from any data source. Using them you can work disconnected providing all necessary metadata information by yourself. (You may learn more about different ways to load metadata at the Load Metadata demo project that included in the Trial version)

• See the full list of features of Delphi Query Builder (VCL Edition).

• Delphi Query Builder. Feature Matrix
• Delphi Query Builder. Reasons to use
• Delphi Query Builder. Screenshots
• Delphi Query Builder. Download
• Delphi Query Builder. Purchase