Downloads

Active Query Builder VCL Edition History

December 01, 2011

Active Query Builder VCL Edition v.1.18.0

= AnyDAC: package name is corrected in order to comply with version 5.
= Advantage: package name for Delphi XE is corrected.
= Russian translation is updated.

November 21, 2011

Active Query Builder VCL Edition v.1.17.13

- Fixed: Aliases in ORDER BY are used for queries with unions only.
+ The SelectItem property is added to the QueryStatistics.OutputColumn's items.

November 07, 2011

Active Query Builder VCL Edition v.1.17.12

- Small memory leak is fixed.
- "Invalid pointer operation" error introduced in version 1.17.9 is fixed.

November 01, 2011

Active Query Builder VCL Edition v.1.17.11

+ Support of ORDER BY in queries with unions is improved.
+ Yet another bunch of speed optimizations is made.

October 28, 2011

Active Query Builder VCL Edition v.1.17.10

+ MS SQL Server: Support of variables as query datasources is made. 
  (select * from @variable)
+ MySQL: Parsing of nested functions is speeded up.
- Fixed bug with qualified names comparison introduced in the previous version.

October 26, 2011

Active Query Builder VCL Edition v.1.17.9

+ Parsing and working with large queries is speeded up.
+ PostgreSQL: list of builtin functions is added.
+ IBM DB2: The new TacDB2SyntaxProvider.NamingConvention property is added. It 
  allows to change the delimiter that split parts in fully qualified object names.
  Available values: db2ncSql (dot), db2ncSystem (slash).

October 11, 2011

Active Query Builder VCL Edition v.1.17.8

= Ordering for the query column is removed now when grouping become unchecked;
  grouping is checked when ordering added.
= Grouping is turned on for the query column when user indicates it's conditions
  to be appled for groups (i.e. to the HAVING clause).
= MS SQL Server: "FOR XML" clause is updated to support Ms Sql Server "Denali".
= MySQL: COALESCE, GREATEST, LEAST and INTERVAL added to the list of builtin
  functions.
= PostgreSQL: Function "substring('test',1,2)" is converted to "substring('test'
  from 1 for 2)" on parsing the query.
= Firebird: INT type alias is supported.
- AV when editing the query columns list in rare cases is fixed.
- Assignment of unnecessary aliases for expressions in rare cases is fixed.

September 02, 2011

Active Query Builder VCL Edition v.1.17.7

= QueryStatistics.OutputColumns.ExpressionAlias is now unquoted.
= Conditions aren't turned to HAVING automatically for grouped query columns.
+ The new methods are added to ease the query analysis and modifcation: 
  TacQueryBuilder.GetSubQueriesList and GetUnionSubQueriesList,
  TacUnionGroup.GetUnionSubQueriesList.
- Oracle: TRANSLATE function is fixed.

August 25, 2011

Active Query Builder VCL Edition v.1.17.6

+ The check box is added to the Grouping column header. It allows to quckly 
  toggle the grouping for the query on and off.
= Now using DevExpress PageControl v3 by default.
= DevExpress controls package names are corrected.
- Adding objects with same AltName from the database objects tree is fixed.

August 23, 2011

Active Query Builder VCL Edition v.1.17.5

+ The check box is added to the Grouping column header. It allows to quckly 
  toggle the grouping for the query on and off.
- MySQL: Reversed displaying of foreign key relationships is fixed.
- Exception is not raised now if the OleInitialize call is failed. 
  It's necessary for OLE drag'n'drop functionality.
- PostgreSQL: Parsing of SUBSTRING function and ARRAY literals is made.
= The new TacQueryBuilder.RefreshDatasourcesMetadata function is made. It is
  needed to allow metadata refreshing without reloading of the current SQL text.