Downloads  »  Active Query Builder VCL Edition History

October 13, 2016

Active Query Builder VCL Edition v.1.26.28

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

+ Query Transformer is now capable to rename output query columns.
+ The new TacQueryTransformer.RenameDuplicatedColumns property prescribes 
  to explicitly specify all the columns in the query SELECT list by
  expanding the asterisk items, then find and rename the unnamend and 
  duplicated column names (default = false).
+ The new TacQueryTransformer.AlwaysExpandColumnsInQuery instructs to 
  perform asterisk expansion in the query SELECT list even if it's not
  needed for the specified query transformations (default = false).
! The TacOutputColumn.Name property has been renamed to OriginalName.
+ The new TacOutputColumn.PreassignedName allows specifying the needed name
  for a query output column.
+ The new TacOutputColumn.ResultName gets the result query columns name,
  which turned out as a result of automatic columns renaming routine and
  manual appliance of the new name specified via the PreassignedName 
  property.
- QueryTransformer: The bug with sorting by a column, which alias is equal 
  to the field name, has been fixed.
- The "Build Expression" popup menu item is now shown only when a handler
  is assigned to the OnCustomExpressionBuilder event.
- MS SQL Server: CHAR(n) parser ambiguity has been fixed.
- MS SQL Server: CHAR and NCHAR have been moved from the builtin functions
  to the list of valid identifiers.
+ PostgreSQL: Support for custom aggregate functions has been added.
- PostgreSQL: Date/time parts have been added to the list of valid
  identifiers.
= ElevateDB packages have been updated to comply with the latest version.

[           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