Active Query Builder

Active Query Builder 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

• Completely visual building of complex SQL queries.
• MS-Access style and SQL Server style interface.
• User-friendly interface with drag & drop support.
• Sophisticated SQL parser.
• Delicate handling of user queries.
• Oracle, SQL Server, MS Access, MySQL, PostgreSQL, Informix, InterBase, Firebird, SQLite and ANSI SQL/92, SQL/89 dialects support.

Image Gallery - Click Image to Enlarge

Detailed Product Description

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.
  • Sophisticated SQL parser.
  • Oracle, SQL Server, MS Access, MySQL, PostgreSQL, Informix, InterBase, Firebird, SQLite and ANSI SQL/92, SQL/89 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 both .NET Framework 1.1 and 2.0.

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