Active Query Builder ActiveX Edition - Summary

Overview | Pricing & Licensing | Evals & Downloads | Compatibility | Publisher Details | Reviews | Support Forum | Summary

Summary

Active Query Builder ActiveX Edition by Active Database Software

Build complex SQL queries via an intuitive visual interface. Active Query Builder is a .NET-ready ActiveX visual query builder component which gives your end-users the ability to create complex SQL queries containing unions and sub-queries via an intuitive visual interface. Active Query Builder has complete support of Oracle, Microsoft SQL Server, MySQL, PostgreSQL, Interbase/Firebird, SQLite and ANSI-92 SQL dialects and can be integrated with your application by setting a few properties or adding a few lines of code.

Overview

Active Query Builder is a .Net-ready ActiveX visual query builder component that allows your end-users to build complex SQL queries via an intuitive visual interface.

Active Query Builder includes an SQL parser that correctly handles SQL queries containing multiple nested joins and other fine points of SQL syntax. Another feature is the graphical engine that allows you to build queries involving unions and sub-queries.

The interface of Active Query Builder is similar to either MS-Access or SQL Server visual query construction interface. The features of Active Query Builder include the ability to build queries with unions and sub-queries.

Active Query Builder supports SQL Server, Oracle, MySQL, PostgreSQL, Interbase/Firebird, SQLite, and ANSI-92 SQL dialects. The sophisticated Active SQL parser can translate any valid SQL statement into it's visual representation.

ActiveX Query Builder controls and iterfaces 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. The component may be integrated into your application with just a few lines of code.

ActiveX Query Builder can be used as a Windows Forms .NET control as easy as ActiveX control. You can simply work with the wrapper class that calls appropriate properties, methods and events from the COM dll. Using ActiveX Query Builder in .NET application you don't even need to register COM object server, so you can deploy your solutions without registration. The only thing you need is .NET Framework!

Note: Active Query Builder Standard ActiveX Edition with Source Code comes with VCL Edition with Source Code.

What's new in the Active Query Builder version 1.9.1

Common changes for ActiveX and VCL

Sleep mode is implemented - This mode allows you to suppress error messages while printing unsupported statements in SQL text editor, connected with Active Query Builder. Active Query Builder now switches to Sleep mode when non-SELECT statement is passed to the SQL property. This allows your end-users to write any other statements, such as INSERT, UPDATE, DELETE, CREATE ..., ALTER ..., etc., without any additional processing

New properties are added to parenthesize conditions in WHERE clause

The new boolean QueryBuilder.TreeOptionsMetadata.HideSingleDatabaseNode property is added to hide the database node from metadata objects tree when there is only one database is loaded to the metadata container

The new demo is added to illustrate ability to replace real object and field names with user-friendly alternate names (Demos/AlternateNames)

PostgreSQL query properties form is added

Numerous fixes in MySQL, DB2, Sybase and other SQL dialects

Chinese, Italian, German and Portuguese (Brazil) localizations files are updated. Spanish, Czech, Turkish and Japanese localization require updating

What's new in Active Query Builder V1.9.0.8

The new Universal Syntax Provider is added to the Free version - It is based on the ANSI SQL/92 syntax but allows to determine most of popular database servers, thus it successfully retrieves metadata and applies specific settings for them, to let the user build simple queries for these servers

Firebird syntax: common table expressions are supported now

What's new in Active Query Builder V1.8.5

Unicode support is implemented in the Columns pane and in all of the Properties windows. (The rest of the visual controls were already Unicode compatible before)

Appliance of the ObjectPrefixSkipping property to the drop-down list of database objects in the Columns Pane is made

Firebird syntax: common table expressions are supported now. (Standard Edition only)

DB2 Syntax: Fixed problems with metadata retrieval for specific server versions. (Standard Edition only)

What's new in Active Query Builder V1.7.9

Chinese, Czech and Italian localizations are 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

What's new in Active Query Builder 1.7.7?

Ability to convert queries between dialects is implemented

Spanish localization is added

The component has became digitally signed, so now there will be no problems with automatic installation from Internet and displaying on client machines using Windows XP SP2 and/or Internet Explorer 7

PartNumbers: PC-516519-156652 516519-156652 PC-516519-156653 516519-156653 PC-516519-156654 516519-156654 PC-516519-156655 516519-156655 PC-516519-156656 516519-156656 PC-516519-156657 516519-156657

Publisher PartNumbers: 1655447 1655448 1655450 1655451 1732492 1732494

PurchaseOptions: Active Query Builder Standard ActiveX Edition V1.9.1 1 Developer License , Active Query Builder Standard ActiveX Edition V1.9.1 4 Developer Team License , Active Query Builder Standard ActiveX Edition V1.9.1 8 Developer Team License , Active Query Builder Standard ActiveX Edition V1.9.1 with Delphi Source Code 1 Developer License (Includes VCL Edition with Source) , Active Query Builder Standard ActiveX Edition V1.9.1 with Delphi Source Code 4 Developer Team License (Includes VCL Edition with Source) , Active Query Builder Standard ActiveX Edition V1.9.1 with Delphi Source Code 8 Developer Team License

Resources: Read the Active Query Builder Quick Start Guide (includes sample Source), Read the Active Query Builder Help, Read the Active Query Builder License Agreement, Download the Active Query Builder Demo, Download the Active Query Builder ActiveX Free Edition on to your computer - Limited Functionality

Operating System for Deployment: Windows XP, Windows Server 2003, Windows ME, Windows 2000, Windows 98, Windows NT 4.0, Windows 95

Architecture of Product: 32Bit

Product Type: Component

Component Type: ActiveX OCX

Built Using: ActiveX Framework

Compatible Containers: Microsoft Visual Studio 2005, Microsoft Visual Studio .NET 2003, Microsoft Visual Studio .NET, Microsoft Visual Studio 6.0, Microsoft Visual Basic 2005, Microsoft Visual Basic .NET 2003, Microsoft Visual Basic .NET, Microsoft Visual Basic 6.0, Microsoft Visual C++ 2005, Microsoft Visual C++ .NET 2003, Microsoft Visual C++ .NET, Microsoft Visual C++ 6.0, Microsoft Visual C# 2005, Microsoft Visual C# .NET 2003, Microsoft Visual C# .NET, Microsoft Visual FoxPro 6.0, Microsoft Office 2003, Microsoft Office XP, Microsoft Office 2000, Microsoft Access 2003, Microsoft Access 2002, Microsoft Access 2000, Microsoft Access 97, Microsoft Access 95, Microsoft Access 2.0, Microsoft SQL Server 2005, Microsoft SQL Server 2000, Microsoft SQL Server 7.0, Oracle Database 9i, Oracle Database 10g, .NET Framework 2.0, .NET Framework 1.1, .NET Framework 1.0, MySQL 5.0, MySQL 4.1

Keywords: SQL query language Author sql query visual query builder