Active Query Builder

Active Query Builder VCL Edition

Visual SQL Query Builder for Delphi and C++ Builder

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

Active Query Builder VCL Edition has a powerful SQL parser that lets you analyze and modify complex SQL queries. Active Query Builder is a true two-way query builder, so that you can combine visual query building with direct SQL query text editing.

Active Query Builder VCL Edition requirements

• Supports Borland Delphi 5-7, Borland C++ Builder 6, BDS 2005-2010, RAD Studio XE, XE2 and XE3 (Delphi and C++ Builder development environments).
• Can be linked with any data access components.
• Successfully tested in x64 applications.
• Can be compiled with standard VCL, TNT or DevExpress controls.

Main Features of Active Query Builder VCL Edition

• Simple and clear visual SQL query building interface
  
  • Easy 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).
  • Customizable SQL query text formatting.
  Learn more about the user interface »
  
  
• Customizable query building environment
  
  • Complete substitution of unintelligible object and field names for user-friendly aliases.
  • Representing high-usage expressions and sub-queries as ordinary database objects and fields.
  Learn more about customizing the environment »
  
  
• Easy metadata management
  
  • Manual hiding of unwanted objects, automatic filtration by schema or object name.
  • Loading metadata programmaticaly from different sources (via web services or from datasets).
  • Working disconnected from the database, storing metadata in XML files.
  Learn more about metadata management »
  
  
• Powerful API to analyze and modify SQL queries
  
  • Restricting access to unwanted objects, preventing SQL query execution.
  • Quick access to the information about database objects, fields and parameters used in the query.
  • Easy query modification for adding custom criteria, changing ordering and limiting query results.
  • Full access to internal query representation obejcts for SQL query analysis and modification.
  Learn more about programming API »
  
  
• Ability to compile the component with DevExpress VCL controls or with Unicode-enabled visual controls from TNT Library

  Compilation of Active Query Builder with third-party controls will enable 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 the source code only as far as required for 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 for the other ways to load metadata to the query builder from any data source. By using them you can work disconnected, providing all the necessary metadata information by yourself. (You can learn more about the different ways to load metadata at the Load Metadata demo project that is included in the Trial version)

• Full feature list of Active Query Builder VCL Edition.

• Delphi VCL Query Builder. Reasons to use
• Delphi VCL Query Builder. Download Free Trial
• Delphi VCL Query Builder. Purchase