Active Query Builder ActiveX Edition 1.13
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.
- Other minor improvements and bugfixes.
- Firebird syntax: common table expressions are supported now.
- The new Universal Syntax Provider is added to the Free version for better compatibility with specific database servers.
+ Ability to define alternate names for database objects and fields.
+ Support of IBM DB2 and ANSI SQL/2003 standard dialects.
+ Six new languages were added.
- Support of Synonyms and Analytic Functions in Oracle, Join Object Hints, Ranking and Aggregate Window Functions in MS SQL Server, more precise erroneous token reporting, other SQL parsing improvements;
- Many other bugfixes and improvements.
...Active Query Builder is a query...builder component suite that...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 containing multiple...fine points of SQL syntax. Another feature...
...Active Query Builder is a visual...SQL query builder .NET component that...to build complex SQL queries via an...intuitive visual query building interface easily....choice for both SQL beginners and experienced...query writers. Active Query Builder renders all...SQL features, such as...The interface of Active Query Builder is...
...query without SQL! Fast...Query Builder is a visual...SQL query builder. You can...use Fast Query Builder in your applications...Builder environment for simple...SQL generator creation. Fast...Query Builder enables to work...2005 and C++ Builder 4, 5, 6...supports 2. Keeping query visual model for...
...Active Query Builder Java Edition is...a visual component for Java...to build complex SQL queries visually via...graphical interface easily. Active Query Builder renders...all SQL features, such as...choice for both SQL beginners and experienced...query writers. The interface...of Active Query Builder is similar to...
...Active Query Builder is a true...two-way visual query builder component for Delphi...and C++ Builder that allows your...to build complex SQL queries via an...intuitive visual interface similar to...query has its own...as single query. Active Query Builder supports...Oracle, SQL Server, MS Access,...