Downloads  »  Active Query Builder 3 Core Edition History

October 26, 2016

Active Query Builder 3 Core Edition v.3.2.0.1029

Below is the list of fixes and improvements in Active Query Builder 3 Core Edition v.3.2.0.1029.

+ Query Transformer is now capable of renaming output query columns.
+ The new QueryTransformer.RenameDuplicatedColumns property prescribes 
  to explicitly specify all the columns in the query SELECT list by
  expanding the asterisk items, then find and rename the unnamed and 
  duplicated column names (default = false).
+ The new QueryTransformer.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 OutputColumn.Name property has been renamed to OriginalName.
! The QueryTransformer.FindColumn method has been replaced with the 
  FindColumnByOriginalName and FindColumnByResultName methods.
+ The new OutputColumn.PreassignedName allows specifying the needed name 
  for a query output column.
+ The new OutputColumn.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.
= Batch query column items processing on grouping on/off has been made.
- QueryTransformer: The bug with incorrect ORDER BY generation if column
  alias is the same as field name has been fixed.
= QueryTransformer: The new SQLGenerationOptions property has been added,
  the SQLBuilder property has been removed.
= The InvalidOperationException is thrown now if both MetadataName and
  MetadataObject properties of the MetadataItem object are specified.
+ PostgreSQL: Support of custom aggregate functions has been made.
- MS SQL Server: CHAR and NCHAR, ROW and ROWS are added to the list of 
  valid identifiers.
- Firebird: The simple form of the TRIM function is supported now.
- Oracle: Special form of the TRIM function is supported now.
= Demo projects are updated and fixed.

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

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

» Full Active Query Builder 3 Core Edition history