Active Query Builder is an ActiveX control software that enable users to easily create SQL queries with its user-friendly interface and unique research capabilities. Ideal for both new and experienced SQL writers, it is .Net-ready and offers a true two-way query builder.
Active Query Builder ActiveX Edition is a powerful control that enables the development of complex SQL queries easily and efficiently. Its intuitive visual interface, similar to MS-Access, allows you to define grouping and sorting and construct criteria in a simple and direct way.
The software offers a range of useful features including the ability to work with each union and sub-query in its own separate working area, making visual query building as easy as building single queries. Active Query Builder is a genuine two-way query builder, allowing users to combine visual query building with direct SQL query editing.
Another useful tool provided by the software is the sophisticated Active SQL parser that can translate any valid SQL statement into its visual representation. Additionally, the SQL Formatter enables you to customize the layout of SQL code to suit your preferences.
The software also helps prevent the execution of unauthorized queries, by allowing users to retrieve various information about the query, such as a list of used tables and fields.
Active Query Builder supports a broad range of SQL dialects, including Oracle, Microsoft SQL Server, MS Access, MySQL, PostgreSQL, Informix, Sybase, Interbase, Firebird, and many others.
The software can be used both online and offline, making it an ideal solution for cases where direct connection to the database is not desirable due to security or performance issues, such as in the ASP.NET environment. When working in offline mode, metadata information can be loaded from a previously saved XML file, allowing for almost instant loading of metadata regardless of the number of objects being loaded.
The latest version of Active Query Builder lets users replace real table and field names with user-friendly aliases, further enhancing the software's usability. Active Query Builder can be used in any software project that supports ActiveX controls, as well as in .Net projects, making it flexible and versatile. It has been successfully tested in Windows.Forms and ASP.NET environments, with .NET Framework 1.1 and higher.
The software offers a range of useful features including the ability to work with each union and sub-query in its own separate working area, making visual query building as easy as building single queries. Active Query Builder is a genuine two-way query builder, allowing users to combine visual query building with direct SQL query editing.
Another useful tool provided by the software is the sophisticated Active SQL parser that can translate any valid SQL statement into its visual representation. Additionally, the SQL Formatter enables you to customize the layout of SQL code to suit your preferences.
The software also helps prevent the execution of unauthorized queries, by allowing users to retrieve various information about the query, such as a list of used tables and fields.
Active Query Builder supports a broad range of SQL dialects, including Oracle, Microsoft SQL Server, MS Access, MySQL, PostgreSQL, Informix, Sybase, Interbase, Firebird, and many others.
The software can be used both online and offline, making it an ideal solution for cases where direct connection to the database is not desirable due to security or performance issues, such as in the ASP.NET environment. When working in offline mode, metadata information can be loaded from a previously saved XML file, allowing for almost instant loading of metadata regardless of the number of objects being loaded.
The latest version of Active Query Builder lets users replace real table and field names with user-friendly aliases, further enhancing the software's usability. Active Query Builder can be used in any software project that supports ActiveX controls, as well as in .Net projects, making it flexible and versatile. It has been successfully tested in Windows.Forms and ASP.NET environments, with .NET Framework 1.1 and higher.
What's New
Version 1.13:
- Firebird 2.5 support is added.
- Other minor improvements and bugfixes.