Downloads

Active Query Builder VCL Edition History

February 22, 2008

Active Query Builder VCL Edition v.1.8.5.11

+ The new LoadMetadata demo is added instead of the EventMP demo.
+ The new boolean TacQueryBuilder.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.
+ TacEventMetadataProvider: Two new events are added: OnGetSynonyms and
  OnGetSystemSynonyms.
+ Minor changes in the installer.

January 24, 2008

Active Query Builder VCL Edition v.1.8.5.9

+ ODBCExpress connectivity package was added (www.odbcexpress.com).
+ The new event TacQueryBuilder.OnFilterSynonym is added in addition to
  OnFilterTable, etc.
- Fixed rare memory leak regarding non-destroying of some internal visual
  controls in the TacQueryBuilder.DestroyControls method.
- QueryBuilder didn't regenerate SQL on syntax provider change. Fixed now.
- Now QueryBuilder clears checks marks on selected fields on syntax provider
  change.

January 23, 2008

Active Query Builder VCL Edition v.1.8.5.8

+ Some locking was added to use parsers in multithreaded environment.
- DB2: The missing aggregate functions Avg, Count, Count_Big, Grouping were added.
- Oracle syntax: The erroneously added aggregate functions Count_Big, Checksum_Agg
  were removed.
- SQLDirect metadata provider: The SQLDirect package name was corrected in
  references for D2007.

January 12, 2008

Active Query Builder VCL Edition v.1.8.5.6

* Autodetection of MySQL server version set On by default.
+ Firebird: Added support of CTE expressions for Firebird 2.1.
- The missing AnyDAC metadata provider packages are added.
- Fixed incompatibility in the ElevateDB metadata provider with version 1.07.

December 27, 2007

Active Query Builder VCL Edition v.1.8.5.3

- Minor fixed in the installation package were made.

December 24, 2007

Active Query Builder VCL Edition v.1.8.5.2

+ The new metadata provider for AnyDAC (www.da-soft.com) is added.
+ The new metadata provider for NativeDB (www.nativedb.com) is added.
- AQB didn't allow to select the expression for output on some stages of building
  queries with grouping. Fixed now.

December 18, 2007

Active Query Builder VCL Edition v.1.8.5.0

+ Added possibility to compile the component on the base of TNT Unicode visual
  library. (this option is available for the customers of Standard version with
  Source Code only)
+ TacQueryBuilder: The new OnAfterCreateControl and OnBeforeDestroyControl
  events were added to configure internal properties of query builder controls.
- MS SQL Syntax: The bug with parsing of CTE sub-queries is fixed.
- Other minor bugs were fixed.

December 13, 2007

Active Query Builder VCL Edition v.1.8.0.13

+ SQL2003 Syntax: The CURRENT_DATE, CURRENT_TIME and LOCALTIMESTAMP constants 
  are supported now.
+ Firebird syntax: common table expressions are supported now.
+ Appliance of the ObjectPrefixSkipping property to the drop-down list 
  of database objects in the Columns Pane is made.
- Fixed falling into the recursion when using an unaliased query with ORDER BY
  clause, if the select item alias is specified in the ordering list.

December 07, 2007

Active Query Builder VCL Edition v.1.8.0.12

- The EventMetadataProvider did not call the GetSQLFieldsList event. Fixed now.
+ EventMetadataProvider: The new events OnLoadTableMetadata, OnLoadViewMetadata,
  OnLoadProcedureMetadata, OnLoadSynonymMetadata are added. Use them to load the
  fields list for appropriate objects using the TacMetadataObject reference.
+ Oracle syntax: QueryBuilder now has support of Oracle specific types.

December 05, 2007

Active Query Builder VCL Edition v.1.8.0.11

- Minor fixes were made.