Downloads

Active Query Builder 3 WinForms Edition History

January 04, 2023

Active Query Builder 3 WinForms Edition v.3.9.6.2238

+ Re-ordering datasources in inner groups of the FROM clause is possible now.
= MS SQL Server: Alias for table-valued functions is required now.
- Printing of unrecognized aggregates is fixed.
- Oracle: Support for VALIDATE_CONVERSION built-in function is corrected.

October 24, 2022

Active Query Builder 3 WinForms Edition v.3.9.5.2237

= DataSourceGroup: The new method SetNewDataSourcesOrder is added to reorder
  datasources within a group.
= DB2: "TABLE_NAME" and "TABLE_SCHEMA" functions from metadata queries as they
  don't exist in older DB2 versions.
- The bug with restoring UserQueries is fixed.
- Minor high-DPI fixes are made.
- Design Pane: Objects drag-n-drop is fixed.
- Design Pane: The bug with selecting fields in datasources with the Ctrl key is
  fixed.

September 20, 2022

Active Query Builder 3 WinForms Edition v.3.9.4.2236

+ SAP Hana: Support for CHAR builtin function is added.
- Query Column List: visual artifacts are eliminated.
- Query Column List: the invisible checkbox column is fixed.

August 29, 2022

Active Query Builder 3 WinForms Edition v.3.9.2.2234

- Wrapping into a derived table for queries with CTE is fixed.

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.