Downloads

Active Query Builder 3 WinForms Edition History

August 22, 2022

Active Query Builder 3 WinForms Edition v.3.9.1.2233

= DB2: The query to load objects is optimized.
= DevExpress: Theming support is improved.
- DevExpress: Borders colors for DataSource Control is fixed.
= Oracle: Non-default scale for numeric fields is shown.
- Wrapping into a derived table is corrected.
- SQL Text Editor: The paint of suggestion items is improved.

July 15, 2022

Active Query Builder 3 WinForms Edition v.3.9.0.2232

+ Now it's possible to select multiple datasources in the Design Pane in 
  different ways:
  - select all datasources in a rectangular area with the mouse, 
  - select individual datasources while holding the Ctrl key,
  - select all the intermediate datasources between the given two ones
    (by joins) holding the Shift key.
+ The new "Wrap into derived table" action is added to the datasource 
  context menu to pack one or several datasources in a new derived table 
  preserving the joins and conditions in the current subquery. 
= The new BehaviorOptions.GenerateWhereConditionsForAggregates property is 
  added to set the "for values" option for aggregated query column list 
  items by default.
- Pervasive: SQL parser ambiguity in datetime functions is eliminated.

July 05, 2022

Active Query Builder 3 WinForms Edition v.3.8.29.2230

= The minimal target framework for ActiveQueryBuilder.View.WinForms assembly
  is reverted to .NET 4.0. Both net48 and net40 versions are packed to the NuGet
  package.
- The bug with selecing table.* elements in sub-queries is fixed.
- The bug on launching precompiled Full-featured Professional demo is fixed.

July 01, 2022

Active Query Builder 3 WinForms Edition v.3.8.28.2229

= References to DevExpress assembiles are updated to v.22.1.3.
- The bug on loading fields with Alternate Names is fixed.

June 28, 2022

Active Query Builder 3 WinForms Edition v.3.8.27.2228

- The bug in SubQuery.CanMoveCTETo for CTEs with subqueries is fixed.
- Design Pane: Scroll bars painting and visibility is fixed.
- The NRE on moving CTE on the Subquery Navigation Bar is eliminated.
- Field list calculation for subqeries with alternate names is fixed.

June 17, 2022

Active Query Builder 3 WinForms Edition v.3.8.26.2227

+ Per-monitor scaling is improved.
= Subquery Navigation Bar: Usability is improved.
= Derived table and CTE context menus are revised.
- Subquery fields list calculation using AltNames is fixed.
- The loading of links with OUTER joins is fixed.
- Serialization of MetadataStructureItem.MetadataName is fixed.

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.