Downloads  »  Active Query Builder ActiveX Edition History

October 13, 2016

Active Query Builder ActiveX Edition v.1.26.28

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

+ Query Transformer is now capable to rename output query columns.
+ The new property aqbxQueryTransformer.RenameDuplicatedColumns property 
  prescribes to explicitly specify all the columns in the query SELECT list 
  by expanding the asterisk items, then find and rename unnamend and 
  duplicated column names (default = false).
+ The new aqbxQueryTransformer.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 aqbxOutputColumn.Name property is renamed to OriginalName.
+ The new aqbxOutputColumn.PreassignedName allows to specify the needed name
  for a query output column.
+ The new aqbxOutputColumn.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 field name is 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 is fixed.
- MS SQL Server: CHAR and NCHAR are moved from the builtin functions to the 
  list of valid identifiers.
+ PostgreSQL: Support for custom aggregate functions is added.
- PostgreSQL: Date/time parts are added to the list of valid identifiers.

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

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

» Full Active Query Builder ActiveX Edition history