Active Query Builder NET Edition description
True two-way Query Builder .NET component to build complex SQL queries easily.

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. It is a perfect choice for both SQL beginners and experienced query writers. Active Query Builder renders all SQL features, such as sub-queries and unions, very easy to accomplish and provides the professional user with everything he or she needs to efficiently work with queries.

The interface of Active Query Builder is similar to MS Access and SQL Server's visual query building interface, so it is already familiar to most database users. Active Query Builder practically eliminates mistakes when writing SQL queries while achieving almost instant results. By embedding Active Query Builder into your product, you can make it easy for beginners and provide a powerful tool for professionals.

Active Query Builder provides maximum flexibility to your users without your software losing control over the operations it performs: the fields and tables the user selects in a query and the data that gets displayed on the screen. No more parameter problems; Active Query Builder lets you find out not only each parameter's name but also the names of each table and field that each parameter applies to.

Active Query Builder gives you full control over the SQL query - you can easily navigate it using the internal query builder objects tree that represents all parts of the SQL query. You can edit existing queries or even create new SQL queries in run-time.

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

This special component hasn't been made to fulfill some internal needs, it was created to specifically meet your needs!

Here are some key features of "Active Query Builder NET Edition":

· Completely visual building of complex SQL queries.
· 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
· Sophisticated SQL parser.
· SQL Server, Access, Oracle, MySQL, PostgreSQL, Firebird, Sybase, IBM DB2, Informix and ANSI SQL/92 dialects support.
· Direct connect to VistaDB 3 and Advantage Database Server.
· SQL Formatter.


Requirements:

· Windows.Forms
· .NET 2.0 environment


Limitations:

· ANSI-92 SQL dialect only
· No access to Metadata Container