Downloads

Active Query Builder History History

January 27, 2022

Active Query Builder History v.3.8.16.452

= References to ActiveQueryBuilder.Core references are updated.
- Exception if ASP.NET session is not configured and isn't used are eliminated.
- The bug on adding a CTE with quoted name is fixed.

January 26, 2022

Active Query Builder History v.3.8.16.2218

+ SAP Hana: Support for analytic expressions is made.
- Pervasive DB: Parsing of the DatePart keywords as identifiers are fixed.

January 26, 2022

Active Query Builder History v.3.8.16.2218

+ SAP Hana: Support for analytic expressions is made.
= Design Pane: The hidden fields counter is displayed now on the datasource
  search panel.
- Design Pane: The bug on double-clicking on the datasource control title is
  fixed.
= SQL Text Editor: Suggestions are shown without a delay and blinking now.
= SQL Text Editor: PageUp and PageDown keys now scroll the content of the
  suggestion popup.
- SQL Text Editor: The bug with the display of suggestion popup after the
  BackSpace keypress is fixed.
- Pervasive DB: Parsing of the DatePart keywords as identifiers are fixed.
- The Null Reference Exception in the trial version is fixed.

January 26, 2022

Active Query Builder History v.3.8.16.2218

+ SAP Hana: Support for analytic expressions is made.
= Design Pane: The hidden fields counter is displayed now on the datasource
  search panel.
- The bug on double-clicking on the datasource control title is fixed.
= SQL Text Editor: Suggestions are shown without a delay and blinking now.
= SQL Text Editor: PageUp and PageDown keys now scroll the content of the
  suggestion popup.
- Pervasive DB: Parsing of the DatePart keywords as identifiers are fixed.
= References to DevExpress assemblies are updated to v.21.2.5.
- DevExpress: The height of suggestion popup items is corrected.
- DevExpress: Datasource control context menu location on multi-monitor systems
  is fixed.
- The Null Reference Exception in the trial version is fixed.

January 25, 2022

Active Query Builder History v.2.10.26.837

= MS SQL Server: Support of the AT TIME ZONE operator is added.
+ SAP Hana: Support for analytic expressions is made.
= Informix: The bug with parsing keywords used as identifiers is fixed.
= References to DevExpress assemblies are updated to v.21.2.5.

January 19, 2022

Active Query Builder History v.1.31.7

= Informix: The bug with the impossibility to use some keywords as identifiers
  is fixed.
+ MS SQL Server: Support for the "AT TIME ZONE" operator is added.
- The exception on loading queries with index-referenced columns in ORDER BY is
  eliminated.
- The bug on selecting the "Check all" action in the datasource field list for
  queries with grouping is fixed.
- The exception on re-calculation of datasource control captions in some cases
  is eliminated.

January 19, 2022

Active Query Builder History v.1.31.7

+ SQL Server: Support for the "AT TIME ZONE" operator is added.
= Denodo Virtualization Server: The list of reserved words is updated.
= Informix: The bug with the impossibility to use some keywords as identifiers
  is fixed.
- TacQueryParametersTransformer: SQL generation is fixed in some cases.
- The exception on loading queries with index-referenced columns in ORDER BY is
  eliminated.
- The bug on selecting the "Check all" action in the datasource field list for
  queries with grouping is fixed.
- The exception on re-calculation of datasource control captions in some cases
  is eliminated.

January 14, 2022

Active Query Builder History v.3.8.15.451

- Minor UI fixes are made.
= References to ActiveQueryBuilder.Core assemblies are updated.

January 13, 2022

Active Query Builder History v.3.8.15.2217

+ The new property QueryBuilder.DesignPaneOptions.ActionsPaneVisible is added
  to hide the top-right panel with quick actions on the Design Pane.
+ The new sample PreserveInitialQueryFormatting is added to give an idea of how
  to preserve the initial SQL query text formatting on load or manual change.
+ Exporting data to MS Excel using FlexCel library is added to the 
  Full-Featured MDI Demo project.
= Target framework for all C# demos is switched to 4.72. Code clean-up is made.
= Object Properties: Value validator is now called in property setters.
- SQL Text Editor: The insertion of special symbols via the ALTGR+key and
  ALT+code key combinations is fixed.
- Informix: Parsing of queries with fields named like keywords is fixed.
- Query Transformer: Correct field references in the WHERE clause is generated
  for wrapped queries with the DISTINCT option.
- Pervasive DB: The IF builtin function parsing is fixed.

January 13, 2022

Active Query Builder History v.3.8.15.2217

+ The new property QueryBuilder.DesignPaneOptions.ActionsPaneVisible is added
  to hide the top-right panel with quick actions on the Design Pane.
+ The new sample PreserveInitialQueryFormatting is added to give an idea of how
  to preserve the initial SQL query text formatting on load or manual change.
+ Exporting data to MS Excel using FlexCel library is added to the 
  Full-Featured MDI Demo project.
= Target framework for all C# demos is switched to 4.72. Code clean-up is made.
= Object Properties: Value validator is now called in property setters.
- Informix: Parsing of queries with fields named like keywords is fixed.
- Query Transformer: Correct field references in the WHERE clause is generated
  for wrapped queries with the DISTINCT option.
- Pervasive DB: The IF builtin function parsing is fixed.