Screenshot Preview

Active Query Builder ActiveX Edition - Summary

by Active Database Software - Product Type: Component / ActiveX OCX

Summary

Active Query Builder ActiveX Edition by Active Database Software

URLs: active-query-builder-activex, active query builder activex, activequerybuilderactivex, active-database, active database, activedatabase

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 ActiveX version 1.22?

The new button is now shown at the right of the focused datasource on Design pane to allow easy adding of linked objects to the query.

Query layout is now preserved after parsing of the modified query.

Algorithm of automatic objects placement on the diagram pane is improved.

Alternate Names now obey server identifier case sensitivity rules.

Table hints are updated according to the SQL Server 2012 specification.

Metadata loading from MS SQL Server Azure is fixed.

Usage of aliases in ORDER BY is corrected.

Other minor fixes and improvements are made.

What's new in Active Query Builder ActiveX v1.17

Behavior changes

The Select checkbox is checked automatically now on adding a new expression.

Grouping is set automatically now on specifying the aggregate for a column now.

The numbers entered into condition for string fields are treated as literals.

The "=TRUE" condition is set automatically on adding a logical expression now. Useful on adding the EXISTS expressions.

Automatic alias assignment is made when user adds two or more columns with same name to the query. The warning message is shown when muptiple columns with same name appear in sub-queries in result of user actions as this may lead to inconsistence in the calling sub-query.

The new UserMessage event is added. It is fired when the Query Builder is about to show the warning message to the user. You may override this behavior by handling this event.

SQL Syntax changes

SQLite: The component can load foreign keys now.

SQLite: The list of aggregates and built-in functions is filled now.

MS SQL Server: Fetching metadata object descriptions from database is made.

MySQL Query Properties form is redesigned.

MySQL: The SELECT [DISTICT|ALL] options are added to the query properties dialog.

ActiveX Edition specific changes:

Nexus DB 3: Metadata fetching is made.

Language files are converted to UTF8. The component allows to read language files in both ANSI and UTF8 encoding now.

OLE drag-and-drop of text items to design area and criteria grid is made.

What's new in the Active Query Builder version 1.15?

General improvements:

New feature: Virtual database objects and fields. It allows to hide complex expressions and sub-queries behind ordinary fields and save derived tables as ordinary database objects. See the Virtual Objects And Fields source code sample for demonstration and details. See below to find the corresponding API improvements for VCL and ActiveX Edition.

Now it's possible to add Common Table Expressions visually using the context menu item of the query building area.

Wheel scrolling in field lists is made.

Spanish and russian translations are updated.

SQL Syntax fixes and improvements:

MS SQL Server, Sybase: Support of the old-style TransactSQL outer join operators ("*=" and "*=") is made.

Firebird: Predefined context variables are supported now: CURRENT_DATE, CURRENT_TIME and CURRENT_TIMESTAMP.

Firebird: "IS DISTINCT FROM" operator is supported now.

Firebird: Parameter names can use the '#' symbols now.

MySQL: Better support of CONVERT function is made.

PostgreSQL, DB2: Metadata filtration is fixed.

PostgreSQL: The list of unifying operators is fixed.

Sybase ASE: Metadata relations loading is fixed now.

MS Access: Bug with unsupported FULL OUTER JOIN is fixed.

ActiveX Edition API improvements:

New properties are added to support virtual database objects and fields:

IMetadataField.Expression and IMetadataObject.Expression (BSTR).

IMetadataField.Expression can contain any correct SQL expression; IMetadataObject.Expression can contain any correct "datasource": an SQL expression which can be used in the FROM clause, i.e. object name, subquery (derived table), etc.

The component will replace all mentions of such fields and objects in result SQL with this expression. Read the IActiveQueryBuilderX.SQLForServer property to get the expanded result SQL text.

The new property IActiveQueryBuilderX.LoadJoinsFromWhereClause: VARIANT_BOOL is added.

Using this property you can instruct Query Builder to not treat WHERE expressions like "tbl1.FieldName = tbl2.FieldName" as joins. They will be loaded as usual WHERE criteria instead.

The new property is made to accept tabs in the columns pane.

IActiveQueryBuilderXControls.SelectListOptions.AcceptTabs: VARIANT_BOOL (default true)

The new property IActiveQueryBuilderX.MetadataXmlFile is added to be able to define it without JavaScript coding.

ParenthesizeSingleCriterion property is applied now to join conditions.

ActiveX Edition other fixes and improvements:

Signed .Net interop assemblies are added to the installation package.

Assertion failed when syntax provider is changed. Fixed now.

DAX error is fixed one more time.

What's new in the Active Query Builder version 1.14?

General fixes and improvements:

SQLite: The query properties form is implemented, Ability to fetch metadata from "attached" databases is added.

Oracle: Retrieval of descriptions for objects and fields from the database is implemented.

The LIKE criteria parsing is improved. Manually entered criteria like "LIKE John Doe" will be distinguished as "LIKE 'John Doe'".

Basic support for custom aggregate functions is implemented.

MS SQL Server: Custom aggregate functions retrieval is made.

MS SQL Server: Parsing of DatePart, DateName, DateDiff, DateAdd functions is fixed.

MS SQL Server: Fixed parsing of fields with names matching datatype names, like "DateTime".

Oracle: Parsing of the SEED keyword is fixed.

Oracle: Parsing of "CONNECT BY" and "START WITH" clauses sequence is fixed.

Oracle and PostgreSQL: interval literals support is added.

Firebird, InterBase: List of reserved words is imported into the grammar.

The INNER keyword can be omitted now in join specifications for Firebird, Interbase and MS SQL Server via the InnerKeywordInLinks property.

SQL dialects without databases support (like Oracle) didn't skip default schema from object names. Fixed now.

Unambiguous reading metadata from XML generated by other AQB Editions (.Net, Java) is made.

CROSS JOIN processing bug is fixed.

AcitveX Edition fixes and improvements:

The new IFieldsListDescriptionColumnOptions.ShowLongDescription property is added to control which description will be shown in the Description column of the fields list:

when it's False (default), the IMetadataField.ShortDescription is shown;

when it's True, the IMetadataField.LongDescription is shown.

The new property is added to create aliases automatically based on alternate names: IActiveQueryBuilderX.SelectListOptions.CreateColumnAliasesFromAltNames.

The new properties are made to control case sensitivity of metadata filter items: IMetadataFilterItem.SchemaMaskCaseSensitive and IMetadataFilterItem.ObjectMaskCaseSensitive.

The new properties are made to force the query builder to show or omit the AS keyword in alias definition: IActiveQueryBuilderX.AsKeywordInExpressionAlias and IActiveQueryBuilderX.AsKeywordInObjectAlias.

The new demo is made to illustrate custom letadata loading in .NET and ASP.NET projects (CSCustomMetadataLoading).

The new property: IActiveQueryBuilderX.SQLSyntaxParams - can be used to control some server-specific syntax options.

The new event is added to change object's captions at the query building area: IActiveQueryBuilderX.OnCustomizeDatasourceCaption.

What's New in Active Query Builder ActiveX V1.12

Possibility to change join type via context popup menu

Manual editing of Join expressions via the Link Properties dialog

PostgreSQL syntax: Support of INTO clause

DB2 syntax: Addition of the Query Properties dialog

MS SQL Server: Support of ranking functions

More optimal grid filling when loading criteria and select list items

Other SQL syntax, usability and API improvements

What's new in Active Query Builder V1.11.5

The new look of Expression column dropdown list is made.

Set of properties is added to take control over the links creation process.

Set of events is added to control over the query building process.

Permanent generation of correct SQL queries with grouping is made.

Numeric condition values for string fields are quoted automatically now.

New context menu items are added to check/uncheck all fields for a datasource.

Other SQL syntax, usability and API improvements.

What's new in Active Query Builder V1.10

Customization of datasource's field lists at the query building area has been made

The FieldsListOptions property allows you to customize drawing of the datasource's field lists. You may show/hide/customize the following columns:

Status picture: is used now to mark Primary key fields only (FieldsListOptions.MarkColumnOptions)

Field Name (FieldsListOptions.NameColumnOptions)

Field Type (FieldsListOptions.TypeColumnOptions)

Field Description: (FieldsListOptions.DescriptionColumnOptions)

Field lists are retrieved now through database server specific queries. This allows to display field types for specific database servers correctly, also this may speed up retrieval of the field lists

Basic support of Mimer SQL dialect is added

MySQL and Firebird parameters parsing is improved

Other minor improvements and bug fixes are made

What's new in Active Query Builder V1.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

Build complex SQL queries via an intuitive visual interface.

Pricing: Active Query Builder Standard ActiveX Edition 1.22 1 Developer License, Active Query Builder Standard ActiveX Edition 1.22 4 Developer Team License, Active Query Builder Standard ActiveX Edition 1.22 8 Developer Team License, Active Query Builder Standard ActiveX Edition 1.22 with Delphi Source Code 1 Developer License (Includes VCL Edition with Source), Active Query Builder Standard ActiveX Edition 1.22 with Delphi Source Code 4 Developer Team License (Includes VCL Edition with Source), Active Query Builder Standard ActiveX Edition 1.22 with Delphi Source Code 8 Developer Team License (Includes VCL Edition with Source), Active Query Builder Standard ActiveX Edition 1.22 Upgrade 1 Developer Upgrade to Standard Subscription with Source Code, Active Query Builder Standard ActiveX Edition - Priority Support 1 Developer 1 Year Priority Support License, Active Query Builder Standard ActiveX Edition - Priority Support 4 Developer 1 Year Priority Support License, Active Query Builder Standard ActiveX Edition - Priority Support 8 Developer 1 Year Priority Support License

Evals & Downloads: Read the Active Query Builder User Guide, Read the Active Query Builder Quick Start Guide (includes sample Source), Read the Active Query Builder DataSheet, Read the Active Query Builder License Agreement, Download the Active Query Builder Demo, Download the Active Query Builder ActiveX Evaluation on to your computer - Limited Functionality

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

Architecture of Product: 32Bit, 64Bit

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 10g, Oracle Database 9i, .NET Framework 2.0, .NET Framework 1.1, .NET Framework 1.0, MySQL 5.0, MySQL 4.1

Keywords: sql query visual query builder

SQL query language

Part numbers: PC-516519-656708 516519-656708 PC-516519-656710 516519-656710 PC-516519-656712 516519-656712 PC-516519-656714 516519-656714 PC-516519-656716 516519-656716 PC-516519-656718 516519-656718 PC-516519-656726 516519-656726 PC-516519-656720 516519-656720 PC-516519-656722 516519-656722 PC-516519-656724 516519-656724

Mfr. Part No: 1655447 1655448 1655450 1655451 1732492 1732494 1923706

Product Search

Enter search words:

The Software Superstore for IT Professionals

As Official Distributors, ComponentSource offers convenient, one-stop shopping from 250+ Software Publishers specializing in Application Development & Operations.

More Info | About Us

Screenshot Gallery

Click for full screen preview

Screenshot of Active Query Builder - ActiveX  - 1.22 Screenshot of Active Query Builder - ActiveX  - 1.22 Screenshot of Active Query Builder - ActiveX  - 1.22 Screenshot of Active Query Builder - ActiveX  - 1.22
Award