Downloads  »  Active Query Builder VCL Edition History

November 11, 2009

Active Query Builder VCL Edition v.1.14.4.0

Below is the list of fixes and improvements in Active Query Builder VCL Edition v.1.14.4.0.

+ New feature: Virtual database objects and fields. It allows to hide complex
  expressions and sub-queries back of ordinary fields and save derived tables as
  ordinary database objects. 
+ New properties are added to support virtual database objects and fields:
  TacMetadataField.Expression and TacMetadataObject.Expression (WideString).
  TacMetadataField.Expression can contain any correct SQL expression;
  TacMetadataObject.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. 
  TacSQLBuilder object will replace all mentions of such fields and objects in
  result SQL with this expression. Programmer can control such expansion using
  the TacSQLBuilder.ExpandVirtualFields boolean property.
+ The new property TacQueryBuilder.LoadJoinsFromWhereClause: boolean is added.
  Using this property you can instruct Query Builder to not treat expressions
  like "tbl1.FieldName = tbl2.FieldName" as joins. They will be loaded as 
  generic WHERE clause expressions instead.
- Metadata relations loading from Sybase ASE is fixed.
- The TacQueryBuilder.TreeOptions.TreeWidth and
  TacQueryBuilder.TreeOptionsMetadata.TreeWidth properties are reflect changes
  in UI immediately now.
- DB2: Metadata filtering is fixed.
- The bug with drawing of table headers when compiled  by lower versions of 
  Delphi is fixed.
- Subquery tab doesn't disappear when user closes a derived table. Fixed now.

[           Legend:          ]
[ + New feature              ]
[ = Improved/changed feature ]
[ - Bug fix                  ]
[ ! Important notice         ]

You can always get the latest trial version of Active Query Builder VCL Edition at the download page.

» Full Active Query Builder VCL Edition history