Downloads

Active Query Builder History History

November 23, 2016

Active Query Builder History v.1.26.29

+ Scrolling by mouse wheel now works in the drop-down pick list of the
  Expression cell editor.
= The FieldListDescriptionColumnOptions.ShowLongDescription property is 
  now set to True by default.
= Minor column type painting improvements in datasource field lists have
  been made.
- Calculation of checked fields in datasource field lists has been fixed.
- The Varchar(Max) and Varbinary(Max) types are displayed correctly now.
- MS Jet: Excel sheet names with the dollar sign are supported now.
- Oracle: Support for the special form of TRIM function has been added. 
- MS SQL Server: ROW and ROWS are added to the list of valid identifiers.
- Other minor bugfixes and improvements have been made.

November 10, 2016

Active Query Builder History v.2.12.4

- Sorting in the Database Schema View by alternate names is performed in the
  appropriate mode.
+ A new row is now added to the Query Columns Grid on double click on a field
  in the Datasource field list, but it doesn't get checked. That allows for a
  quick addition of conditions for fields.

November 01, 2016

Active Query Builder History v.2.12.3

- The bug with double click on an object in results of filtration in the 
  Schema Tree View has been fixed.
- The bug on clicking the "Check all" popup menu command of the datasource
  field list has been fixed.

October 28, 2016

Active Query Builder History v.2.12.2

+ Database objects and fields can be added to the query by double click in 
  the new Objects Tree View.
- The bug with multiple collapsing and expanding nodes of the Objects Tree
  View has been fixed.
- The bug with incorrect quotation of fields has been fixed.

October 28, 2016

Active Query Builder History v.3.2.0.1030

+ Now you can drag Dock Manager tabs from right to left.
- The bug with localizing of the "No properties" caption on the Properties
  Bar has been fixed.
- The arrow button now switches its glyph on changing the state.
- The bug with dragging of union sub-queries on the pinned Sub-Query
  Navigation Bar panel has been fixed.
= References to DevExpress assemblies are updated to the version 16.1.7.0.

October 28, 2016

Active Query Builder History v.3.2.0.1030

= Visual improvements for the SQL Text Editor's suggestion window have been
  made.
- The bug with localizing of the "No properties" caption on the Properties
  Bar has been fixed.
- The bug with saving and loading the size of dock panels has been fixed.

October 26, 2016

Active Query Builder History 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.

October 26, 2016

Active Query Builder History v.3.2.0.1029

+ The QueryBuilder control has got the new controls as dockable panels
  located to the left or right of the Design Pane. 
+ The new the Sub-query Navigation Bar has been made. It was formerly
  available as a pop-up window of the Query Navigation Bar. 
  (Available as a separate control in the Professional subscriptions only)
+ Usability of the Sub-query Navigation Bar is improved: now you can change
  the order of union sub-queries using drag'n'drop.
+ The new Properties Bar allows you to set various query, datasource and
  link properties without the need to open a dialog window. 
  (Available as a separate control in the Professional subscriptions only)
+ The new Dock Manager control has been added. 
  (Available in the Professional subscriptions only)
+ The new properties have been added to the PanesConfigurationOptions:
  SubQueryNavBarEnabled, PropertiesBarEnabled, SubQueryNavBarDockOptions,
  PropertiesBarDockOptions. The two latter property groups determine the
  initial state of appropriate sidebar panels and contain the following 
  properties: AutoHide (True/False), Position (Left/Right).
+ The new property QueryBuilder.DockPanelsLayoutXML has been made to save 
  the layout of sidebar panels between work sessions.
+ The new properties have been added to the QueryBuilder.VisualOptions to
  define colors and font of sidebar panels and its docking system.
= The Query, Datasource, and Link Properties dialogs are redesigned.
+ 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.
+ Localization in the separate controls mode has been fixed.
= The QueryBuilder.Language and QueryView.Language properties are
  redirected to the ActiveQueryBuilder.Core.Helpers.Localizer.Language
  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.
- The bug on resizing QueryColumnList control if cell editor is active has
  been fixed.
- The bug with not displaying fields from derived tables in the Expression
  Editor's tree has been fixed.
+ 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.
- Localization in the separate controls mode has been fixed.
= Demo projects are updated and fixed.

October 26, 2016

Active Query Builder History v.3.2.0.1029

+ The QueryBuilder control has got the new controls as dockable panels
  located to the left or right of the Design Pane. 
+ The new the Sub-query Navigation Bar has been made. It was formerly
  available as a pop-up window of the Query Navigation Bar. 
  (Available as a separate control in the Professional subscriptions only)
+ Usability of the Sub-query Navigation Bar is improved: now you can change
  the order of union sub-queries using drag'n'drop.
+ The new Properties Bar allows you to set various query, datasource and
  link properties without the need to open a dialog window. 
  (Available as a separate control in the Professional subscriptions only)
+ The new Dock Manager control has been added. 
  (Available in the Professional subscriptions only)
+ The new properties have been added to the PanesConfigurationOptions:
  SubQueryNavBarEnabled, PropertiesBarEnabled, SubQueryNavBarDockOptions,
  PropertiesBarDockOptions. The two latter property groups determine the
  initial state of appropriate sidebar panels and contain the following 
  properties: AutoHide (True/False), Position (Left/Right).
+ The new property QueryBuilder.DockPanelsLayoutXML has been made to save 
  the layout of sidebar panels between work sessions.
+ The new properties have been added to the QueryBuilder.VisualOptions to
  define colors and font of sidebar panels and its docking system.
= The Query, Datasource, and Link Properties dialogs are redesigned.
+ 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.
+ Localization in the separate controls mode has been fixed.
= The QueryBuilder.Language and QueryView.Language properties are
  redirected to the ActiveQueryBuilder.Core.Helpers.Localizer.Language
  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.
- The bug on resizing QueryColumnList control if cell editor is active has
  been fixed.
- The bug with not displaying fields from derived tables in the Expression
  Editor's tree has been fixed.
+ 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.
- Localization in the separate controls mode has been fixed.
= Demo projects are updated and fixed.

October 21, 2016

Active Query Builder History v.2.12.1

= The component now restores its state correctly after the session expiration
  if the component was loaded separately from the web page.