Active Query Builder ActiveX Edition is a control to build complex SQL queries via an intuitive visual interface similar to MS-Access, but much more powerful compared to other similar components. It allows you to define grouping and sorting, to construct criteria in a simple and direct way. Each union and sub-query has its own working area where it could be built visually as easy as single query.

Active Query Builder is a true two-way query builder, so you may combine visual query building with direct SQL query editing. The sophisticated Active SQL parser can translate any valid SQL statement into it's visual representation. SQL Formatter will allow you to customize the SQL code layout the way you like it. Ability to retrieve various information about the query, such as list of used tables and fields, allows you to prevent execution of unauthorized queries.

Active Query Builder supports Oracle, Microsoft SQL Server, MS Access, MySQL, PostgreSQL, Informix, Sybase, Interbase, Firebird, and other SQL dialects.

In many cases, direct connection to the database is undesirable or even impossible from the point of view of security or performance, for example in the ASP.NET environment. In this case, the most convenient solution would be to work with Active Query Builder in offline mode, loading metadata information from a previously saved XML file. It also makes loading metadata almost instant regardless of the number of objects being loaded.

The latest version of our component allows you to replace real table and field names with the user-friendly aliases.

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 and .NET, Visual C++ 6.0, Visual C#, PowerBuilder and so on. Active Query Builder was successfully tested in Windows.Forms and ASP.NET environments, with .NET Framework 1.1 and higher.

• Active Query Builder .NET Edition 1.9
  Active Query Builder is a visual SQL query builder .NET component that allows your end-users to build complex SQL queries via an intuitive visual query building interface easily....

• Active Query Builder Java Edition 1.0.5
  Active Query Builder Java Edition is a visual component for Java environment to allow your end users to build complex SQL queries visually via user-friendly graphical interface easily

• Active Query Builder Free Edition 1.13
  Active Query Builder is a query builder component suite that allows your end-users to build complex SQL queries via an intuitive visual interface. It differs from other query builders by its powerful SQL parser that correctly handles SQL queries...

• Active Query Builder Standard Edition 1.0
  Active Query Builder is a query builder component suite for Borland Delphi 6, 7, 2005 and C++ Builder 6 that allows your end-users to build complex SQL queries via an intuitive visual interface

• Active Query Builder ASP.NET Edition 0.1
  This software is the ultimate ASP.NET query builder, a component that will make building SQL queries easier than you could ever have imagined. Active Query Builder ASP.NET Edition provides web developers with the tool they need to build SQL queries visually, using a user-friendly interface in the style of Microsoft Access. This solution is also...

• Database Workbench Lite for MySQL 4.0.3
  Database development IDE for MySQL with many features: visual object editors, schema browser, SQL Insight, two-way visual query builder, templates & catalogs, export and import tools and much more

• FlySpeed SQL Query 2.6.9
  FlySpeed SQL Query allows new and professional database developers to build complex SQL queries in a simple graphical manner