Downloads

Active Query Builder History History

November 10, 2021

Active Query Builder History v.2.10.24.835

= Informix: Keywords list is updated, support for double-quoted strings 
  support (with auto-detection) and curly-braced comments is added.
= MS SQL Server: Support for TRY_CAST and TRY_CONVERT built-in functions is 
  added.
= Teradata: A fallback to non-X system views if X-views are not available is
  made.
= MySQL: Fields are fetched sorted by ORDINAL_POSITION.
= Firebird: Support for CTE in subqueries is turned on.
- SAP Hana: The bug with schemas loading is fixed.

November 10, 2021

Active Query Builder History v.3.8.12.2210

+ Support for Visual Studio 2022 is added.
= Column aliases that are valid identifiers aren't quoted now.  
+ The new BehaviorOptions.AlwaysQuoteColumnAliases property is added. 
  Default is false.
= References to DevExpress assemblies are updated to v.21.2.3.
= MySQL: Fields are fetched sorted by ORDINAL_POSITION.
= MySQL: The ANSI_QUOTES flag is detected during the server version 
  autodetection.

November 10, 2021

Active Query Builder History v.3.8.12.2210

+ Support for Visual Studio 2022 is added.
= Column aliases that are valid identifiers aren't quoted now.  
+ The new BehaviorOptions.AlwaysQuoteColumnAliases property is added. 
  Default is false.
= MySQL: Fields are fetched sorted by ORDINAL_POSITION.
= MySQL: The ANSI_QUOTES flag is detected during the server version 
  autodetection.

November 10, 2021

Active Query Builder History v.3.8.12.2210

+ Support for Visual Studio 2022 is added.
= Column aliases that are valid identifiers aren't quoted now.  
+ The new BehaviorOptions.AlwaysQuoteColumnAliases property is added. 
  Default is false.
= MySQL: Fields are fetched sorted by ORDINAL_POSITION.
= MySQL: The ANSI_QUOTES flag is detected during the server version 
  autodetection.

November 01, 2021

Active Query Builder History v.1.31.5

= Minor internal optimizations were made.

November 01, 2021

Active Query Builder History v.1.31.5

- The bug with loading images from named resources when ActiveQueryBuilder
  resources are compiled into a separate DLL (or BPL package) is fixed.

November 01, 2021

Active Query Builder History v.3.8.11.447

+ The improved context menus for datasource columns on the Design Pane 
  are remade to perform most of the operations without touching the Query 
  Columns Grid.
- Minor UI fixes are made.
- The bug with working without the Query Columns Grid is fixed.
- Enter and Esc keys are handled properly in all dialogs.
= References to ActiveQueryBuilder.Core assemblies were updated.

November 01, 2021

Active Query Builder History v.3.8.11.2209

= Layout: New datasources are repositioned properly now on the new query 
  assignment.
= SQL Text Editor: Shift+Down on the last line selects a row to the end.
= Metadata Editor: More connection types are available in the Metadata Load 
  Wizard out-of-the-box.
= Design Pane: Datasource fields filter panel is collapsed now when user 
  clicks the cross button twice.
+ Informix: Support for databases, double-quoted strings, curly-braced 
  comments are added; the keywords list is updated.
+ SQLite: Date, Time, and DateTime conversion built-in functions are added.
= Firebird: CTE in subqueries are supported now. 
- Oracle: The bug with applying limits for server versions without 
  OFFSET/FETCH support is fixed.
- Oracle: The bug with queries containing DbLink objects has been fixed.
- SQL Text Editor: An exception on text editing in rare cases is eliminated.
- Design Pane: The bug with populating of "Where" datasource fields context 
  menu items is fixed.
= The new QueryRoot.LoadLayoutSqlV2 helper extension method to load 
  the LayoutSql saved in the second version of the component is added
  to the ActiveQueryBuilder.View.Compatibility assembly.
= Full-Featured MDI Demos are updated.

November 01, 2021

Active Query Builder History v.3.8.11.2209

= Layout: New datasources are repositioned properly now on the new query 
  assignment.
= SQL Text Editor: Shift+Down on the last line selects a row to the end.
= Metadata Editor: More connection types are available in the Metadata Load 
  Wizard out-of-the-box.
= Design Pane: Datasource fields filter panel is collapsed now when user 
  clicks the cross button twice.
= The Show/hide button is added to the datasource fields filter panel.
+ Informix: Support for databases, double-quoted strings, curly-braced 
  comments are added; the keywords list is updated.
+ SQLite: Date, Time, and DateTime conversion built-in functions are added.
= Firebird: CTE in subqueries are supported now. 
- Oracle: The bug with applying limits for server versions without 
  OFFSET/FETCH support is fixed.
- Oracle: The bug with queries containing DbLink objects has been fixed.
- SQL Text Editor: An exception on text editing in rare cases is eliminated.
- Design Pane: The bug with populating of "Where" datasource fields context 
  menu items is fixed.
= The new QueryRoot.LoadLayoutSqlV2 helper extension method to load 
  the LayoutSql saved in the second version of the component is added
  to the ActiveQueryBuilder.View.Compatibility assembly.
= Full-Featured MDI Demos are updated.

November 01, 2021

Active Query Builder History v.3.8.11.2209

= Metadata Editor: More connection types are available in the Metadata Load 
  Wizard out-of-the-box.
+ Informix: Support for databases, double-quoted strings, curly-braced 
  comments are added; the keywords list is updated.
+ SQLite: Date, Time, and DateTime conversion built-in functions are added.
= Firebird: CTE in subqueries are supported now. 
- Oracle: The bug with applying limits for server versions without 
  OFFSET/FETCH support is fixed.
- Oracle: The bug with queries containing DbLink objects has been fixed.