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. There are two editions available: the Standard Edition and the Free Edition. The Free Edition is fully functional, but supports only the ANSI-92 SQL dialect.
Active Query Builder is a special component. It wasn't created for some internal needs, it was made to meet your needs!
