Downloads

Active Query Builder 3 WinForms Edition History

June 02, 2022

Active Query Builder 3 WinForms Edition v.3.8.25.2226

! BaseSyntaxProvider: The OnCalcExpressionType is converted from property 
  to event. This change may require manual editing of *.Designer.cs files 
  to remove lines like "OnCalcExpressionType = null;"
= MySQL: Support for JSON extraction operators is added.
= Oracle: Precision for the NUMBER type is displayed now.
= New methods to collect and resolve object name conflicts are added.
- The bug with unchecking datasource fields is fixed.

May 13, 2022

Active Query Builder 3 WinForms Edition v.3.8.24.2225

- DevExpress UI: The icon size in the Database Schema View is fixed.
- DevExpress UI: The bug with loading of layout for DataSource control is fixed.
- Keys typed to the Database Schema View aren't passed to the search box if it
  is hidden.
- The "Item already added" error on setting SQL text in some cases is eliminated.

May 06, 2022

Active Query Builder 3 WinForms Edition v.3.8.23.2224

= Portuguese (Brazilian) localization is updated. 
- DevExpress UI: DataSource control painting, closing and resizing are fixed.
- The bug with SQL layout loading in Trial version is fixed.
- The "queryElement is not null" error on saving query layout in some cases 
  is fixed.

April 28, 2022

Active Query Builder 3 WinForms Edition v.3.8.22.2223

- SQL Text Editor: The bug with large line height is fixed.
- DevExpress: The bug with scrolling in the subquery navigation bar is fixed.

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.