Active Query Builder ActiveX Edition

ActiveX Visual Query Builder

Active Query Builder ActiveX Edition is a visual query builder control that allows your end-users to build complex SQL queries via an intuitive visual interface.

  • 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.
    • 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
  • Wide range of supported development environments

    Active Query Builder can be used in any software project which supports ActiveX controls as well as in the .Net projects. For example, you can use it with Visual Basic 6.0, Visual Basic .NET, Visual C++ 6.0, Visual C#, PowerBuilder, Delphi and so on.

  • .NET-ready ActiveX control

    Active Query Builder ActiveX Edition can be used as a Windows.Forms and ASP.NET control easily. Active Query Builder was successfully tested with .NET Frameworks 1.1, 2.0 and 3.5.

  • Easy integration in your application

    The component may be integrated into your application with just few lines of code. All you need is to setup ADO connection properties and tune ActiveX Query Builder parsing, code generation and visual options.


  • ActiveX Live Demo is available at the web-site.
  • Common product information about Active Query Builder.
  • Full list of features of Active Query Builder ActiveX 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

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