|By Active Database Software. Active Query Builder ActiveX Edition is a .Net-ready ActiveX visual SQL query building component that allows your end-users to build complex SQL queries via an intuitive visual interface easily.
Active Query Builder component suite is a perfect choice for both SQL beginners and experienced query writers. It 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.
Active Query Builder can be used as an unfailing assistant in parsing user queries. 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 is a true two-way query builder. It means that you may combine visual query building with direct SQL query editing. Changes made to the SQL query text will be affected to the query builder immediately.
Active Query Builder supports a number of SQL dialects, including Oracle, MS SQL Server, MS Access, Sybase, Informix, MySQL, PostgreSQL, InterBase, Firebird, SQLite and general ANSI SQL/92 and SQL/89 standards.
ActiveX Query Builder controls and interfaces 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#, Delphi and so on.
Free version available. Free Edition is limited in functionality: only the ANSI-92 SQL dialect parser is included.