Downloads

Active Query Builder 3 WinForms Edition History

April 22, 2022

Active Query Builder 3 WinForms Edition v.3.8.20.2222

- The object reference error on using comparison operators in join statements
  is fixed.

April 21, 2022

Active Query Builder 3 WinForms Edition v.3.8.19.2221

+ DevExpress: Per-monitor HiDPI scaling is improved.
= DevExpress Basic demo: Criteria Builder is added.
= References to DevExpress assemblies are updated to v.21.2.7.
= Query Columns List: Logical expressions such as EXISTS subqueries aren't set
  as visible automatically, but used for filtration purposes by default.
- The bug with not printing aliased object names is fixed.
- Criteria Builder: The display of condition values is fixed.
= MS SQL Server: Support for "FOR JSON" clause is added.
= MS SQL Server: Support JOIN without a type prefix is made.
- PostgreSQL: The bug with loading referencing objects list is fixed.
= Oracle: Support for default value clause for conversion functions is added.
- SAP Hana: Parsing of YEAR/HOUR/MINUTE/... builtin functions is fixed.

February 22, 2022

Active Query Builder 3 WinForms Edition v.3.8.18.2220

+ SQLQuery: New methods to set sort type and order for a QueryColumnListItem are
  added.
= Other minor core updates are made.

February 16, 2022

Active Query Builder 3 WinForms Edition v.3.8.17.2219

+ SQL Text Editor: Auto-completion is made smarter: The suggestion popup 
  sticks to the beginning of the word, finding items by first CamelCase 
  letters, different behavior on selecting an item with Tab, Enter, or Space.
  Several bug fixes are made.
- MS SQL Server: The TIME built-in type parsing is fixed.
- Pervasive DB: The ambiguity in the IF built-in function parsing is 
  eliminated, so parsing is speeded up.

January 26, 2022

Active Query Builder 3 WinForms Edition 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 13, 2022

Active Query Builder 3 WinForms Edition 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.

December 09, 2021

Active Query Builder 3 WinForms Edition v.3.8.14.2212

= HiDPI fixes are made.
= MS SQL Server: Support for the "AT TIME ZONE" clause is made.
- Oracle: The NRE in the code for calculating the expression result type is fixed.
- Scaling of the UserQueries menu icons is fixed.

November 10, 2021

Active Query Builder 3 WinForms Edition 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 01, 2021

Active Query Builder 3 WinForms Edition 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.

September 22, 2021

Active Query Builder 3 WinForms Edition v.3.8.10.2208

+ The new property is added to determine the case of built-in functions and
  variables: SQLGenerationOptions.BuiltinFormat.
= Design Pane: In the field list context menu, the Sorting item is moved to
  the root of the menu, the HAVING item is shown if a query has grouping.
= The SQLFormattingOptions.KeywordFormat property is moved to the
  SQLGenerationOptions class.
= IBM DB2, Informix: Metadata providers are compiled in the AnyCPU mode.
  Make sure that you have the required version of the DB client installed.
= Syntax provider settings forms: The 'Deny INTO clause' option is not shown
  anymore.