Active Query Builder VCL Edition

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

Zoom [+]

Build complex SQL queries via an intuitive visual interface. Active Query Builder is a query builder component suite for Borland Delphi and C++Builder 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, Informix and more SQL dialects and can be integrated with your application by setting a few properties or adding a few lines of code.

Our regular prices are shown below. Please logon to see your discounted prices.

Active Query Builder Standard VCL Edition V1.14

Active Query Builder Standard VCL Edition V1.14 with Source Code

Active Query Builder Standard VCL Edition - Priority Support

Our prices include ComponentSource technical support and, for most downloadable products, an online backup and a FREE upgrade to the new version if it is released within 30 days of your purchase.  All sales are made on our standard Terms and Conditions and subject to our Return Policy. Please contact us if you require any licensing option not listed above including volume licensing and previous versions.

Our regular prices are shown above. Please logon to see your discounted prices.

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.

VCL Edition fixes and improvements:

• The new TacFieldsListDescriptionColumnOptions.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 TacMetadataField.ShortDescription is shown;
    when it's True, the TacMetadataField.LongDescription is shown.
• The new property is added to create aliases automatically based on alternate names: TacQueryBuilder.SelectListOptions.CreateColumnAliasesFromAltNames.
• The new properties are made to control case sensitivity of metadata filter items: TacMetadataFilterItem.SchemaMaskCaseSensitive and TacMetadataFilterItem.ObjectMaskCaseSensitive.
• The new properties are made to force the query builder to show or omit the AS keyword in alias definition. Use the TacQueryBuilder and TacBaseSQLBuilder AsKeywordInExpressionAlias and AsKeywordInObjectAlias properties for this purpose.
• The new methods are added to get database schemes list:
    TacBaseSyntaxProvider.GetSchemaNames - for specific database servers;
    TacBaseMetadataProvider.GetSchemaNames - for generic ADO connections.
• The new TacMSAccessSyntaxProvider.LoadLinkedTables property is made to control loading of linked database objects into metadata container.
• The new events are added to control unchecking of a field from the datasource field list: OnDatasourceFieldRemoving and OnDatasourceFieldRemoved.
• API changes: TacMetadataFieldNamesList class is renamed to TacMetadataQualifiedNameList.

What's New in Active Query Builder VCL V1.13

• Embarcadero RAD Studio 2010 is supported now.
• Support of QuantumTreeList 5 is added, QuantumTreeList 4 is dropped (for DevExpress v.45 and higher)
• The new property InnerKeywordInLinks is added to TacSQLBuilder and TacQueryBuilder components to suppress the "INNER" keyword in joins.
• The new TacQueryBuilder.SelectListOptions.ShowNullOrderingInSortTypeColumn property is added to allow visual setting of NULLS FIRST/NULLS LAST options.
• RemObjects DataAbstract integration is updated.
• Support of ElevateDB 2 is fixed.

What's New in Active Query Builder VCL 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.5

• Support of Embarcadero Delphi 2009 IDE is added.
• Ability to compile the component with DevExpress controls is added.

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

Overview

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

The interface of Active Query Builder for Delphi is similar to either MS-Access or SQL Server visual query construction interface.

Active Query Builder supports Oracle, SQL Server, 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. You can use full range of database connectivity components as well as generic event-driven metadata provider to get metadata information from any data source.

The component may be integrated into a Delphi or C++ Builder application with just a few lines of code. Active Query Builder does not force the programmer to use the embedded data grid, SQL editor or anything else. Instead, it allows you to integrate any accompanying tools into your application as quickly and easily as possible. The product is shipped with a detailed help system and a demo application to help you quickly master the product.

Note: Active Query Builder Standard VCL Edition with Source Code is also included in ActiveX Edition with Source Code.

Support

Priority Support
The Premium Support Program was developed at the request of some of Active Database Software's current and potential customers who have their own support obligations to their end-users, so they have to be sure to receive answers in a timely manner. This program will ensure you receive answers from Active Database Software support staff within 24 hours (excluding weekends and holidays), to have your bug reports processed foremost, and your wishes and suggestions to be placed higher in their to-do list.