Downloads

Active Query Builder 3 WPF Edition History

January 13, 2022

Active Query Builder 3 WPF 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.
- 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 WPF 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.
- The positioning of a new datasource control on the Design Pane after adding it
  via the linked datasource field's button is fixed.

November 10, 2021

Active Query Builder 3 WPF 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.
= 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 WPF 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.
= 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.

September 22, 2021

Active Query Builder 3 WPF 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.
- Minor UI fixes are made.

August 31, 2021

Active Query Builder 3 WPF Edition v.3.8.9.2207

= The field context menu in DataSource controls on the Design Pane has been
  improved when grouping is applied, and the field is used in the query
  several times.
- The field sorting icon is fixed in DataSource controls on the Design Pane
  when the field is mentioned in the ORDER BY several times.
- SQL Text Editor: Search and replace functionality has been fixed.
- SQL Text Editor: Pressing the Ctrl+Backspace key combination removes the
  whole word at the left of the cursor. The Shift+Backspace now acts as the
  Backspace key.

August 13, 2021

Active Query Builder 3 WPF Edition v.3.8.8.2206

= GrapeCity reports module can be activated in the Full-Featured MDI Demo 
  by turning on the EnableActiveReportsSupport property in the Samples\
  Directory.Build.props file. 
- Full-Featured demo: The crush on assigning wrong SQL text to the 
  current subquery text has been eliminated.
- The bug with SQL text generation for objects and fields with empty 
  alternate names when the UseAltNames property is true has been fixed.

July 20, 2021

Active Query Builder 3 WPF Edition v.3.8.7.2205

= The methods to serialize/deserialize query builder option groups are moved
  from the View to Core assembly.
= The bug with SQL query generation with alternate names for servers
  supporting object names as a default alias has been fixed.

July 12, 2021

Active Query Builder 3 WPF Edition v.3.8.6.2204

= MS SQL Server: Support for TRY_CAST and TRY_CONVERT built-in functions has
  been added.
= Objects in the search results are expandable now. 
= Query model optimization has been made. Datasources aren't reordered now if
  not needed.
- Query Columns List: Grouping and aggregate icons in checkboxes are updated.
- Expression Editor: The Query Context panel content is generated correctly
  now.
- The NRE on the component disposal for some complex queries has been
  eliminated. 
- Query Columns List: The bug with displaying the 'Or' column before the
  'Criteria' column has been fixed.

June 23, 2021

Active Query Builder 3 WPF Edition v.3.8.5.2202

- The bug with empty context lists in Expression Editor is fixed.
- The unhandled exception on opening Expression Editor has been eliminated.