此頁只有英文版

Active Query Builder ActiveX/VCL updated

Version 1.14 features improved parsing of LIKE criteria and basic support for custom aggregate functions.

放大 [+]

Screenshot from Active Query Builder VCL Edition.

Active Query Builder is a 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. It features complete support for 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.

• Active Query Builder VCL Edition is designed for Borland Delphi and C++Builder.
• Active Query Builder ActiveX Edition is a .NET-ready ActiveX.

The following editions are also available:

• Active Query Builder Java Edition
• Active Query Builder .NET Edition

Updates in V1.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.

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.

About Active Database Software

Active Database Software, Ltd. is a privately owned software development company. Established in 2005, Active Database Software offers solutions for professional database developers especially designed to make software development easier, faster and more effective. The company aims to provide technologies that save development time by combining powerful capabilities with unmatched ease-of-use.