Active Query Builder ActiveX Edition

.Net-ready Visual Query Builder

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

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


  • 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

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