Active Query Builder 3 WPF Edition History

April 04, 2020

Active Query Builder 3 WPF Edition v.

+ The indication of sorting, aggregation, and conditions for a column in the
  object field list on Design Pane has been made.
+ The new way to define sorting, grouping, aggregations, and sorting via the
  context menu of the datasource field list has been introduced. It also
  helps to switch to the existing condition in the Query Columns grid.
+ It's possible now to define a set of ready-to-use conditions for specific
  fields and data types for instant applying via the datasource field list
  context menu.
+ The user can switch now to sub-queries in WHERE and HAVING parts of the
  query using a button next to a corresponding field in the datasource field
+ Support for the Right-to-left oriented layout has been made.
+ Hebrew and Dutch localizations have been added; other localizations are
= The programmer now has full control over the context menus.

March 20, 2020

Active Query Builder 3 WPF Edition v.

= Now the user can apply conditions to expression value (in the WHERE clause)
  for an aggregated column. (choose "For values" in the "Criteria for" column)
= The "Grouping" flag isn't set now for a newly added column on adding it to 
  the query by double-clicking on a field in the Design Pane.
- The bug with not displaying the link creation buttons in datasources in the
  Design Pane when fields are custom-drawn using the FieldListDrawItem event.
- Query Transformer: The bug with not quoting column aliases when needed has 
  been fixed.
- The bug with adding an incorrect CTE item from the Sub-query Navigation 
  panel has been fixed.
= SAP Hana: Support for the PLACEHOLDER clause has been added.
- SAP Hana: The TRIM function syntax has been corrected.

March 08, 2020

Active Query Builder 3 WPF Edition v.

+ The missing Japanese localization has been added.
= The new MetadataItem.Connection property has been added to support the work 
  with MetadataContainer consolidating items from different DB connections.

February 28, 2020

Active Query Builder 3 WPF Edition v.

+ SQLite: Support for window functions, analytic expressions, and the FILTER 
  clause has been added.
+ PostgreSQL: Support for the FILTER clause is added and the bug with the 
  PRECEDING clause is fixed.
= SQL Text Editor: The missing methods ShowSuggestionWindow and 
  HideSuggestionWindow are added.
= Teradata, ANSI SQL/89: Keywords and functions are added to the suggestion 
  list in the SQL Text Editor.
= SQLite, Teradata, Generic: Support for the REPLACE function is added.
= The QueryColumnListItem.AddExpression method now fires an exception on
  adding an incorrect SQL expression instead of displaying an error to the
- The bug with displaying field names on the design pane in the 
  right-to-left mode has been fixed.
- Other minor bugs are fixed.

February 14, 2020

Active Query Builder 3 WPF Edition v.

+ SAP Hana: Filters are now applied to the metadata fetching process.
+ Server version is detected by default now for Oracle, SQL Server, 
  MySQL, Sybase, and Informix.
= SAP Hana: The list of keywords has been updated.
= Oracle: Metadata loading has been speeded up.
= Oracle: Stored procedure fields are correctly loaded from the server now.
- Duplicated GROUP BY items are handled correctly now.

February 05, 2020

Active Query Builder 3 WPF Edition v.

+ SAP Hana: Support for TOP clause has been added.
- SAP Hana: Parsing of CURRENT_UTC* constants is fixed.
= The Basic demo has been improved.
+ The new type of namespace has been added: Connection.
+ The new ConsolidatedMetadataContainer demo is made to provide sample 
  of loading objects from several DB connections. 
= Installer: It is now possible not to uninstall the previous version.
= Installer: The request to elevate rights emerges now.
= Database Schema View: Database Exceptions on expanding nodes are properly
  handled now and displayed to the user.
- Database Schema View: The wait label is now displayed during the load of
  search results.
- Database Schema View: The bug on adding an object to Favorites from the 
  search results has been fixed.
- ODBC metadata properties form: Properties are applied correctly now.
- Other minor bugs are fixed.

January 13, 2020

Active Query Builder 3 WPF Edition v.

- Oracle: Minor bug in the QueryTransformer is fixed. Column prefixes for 
  inner queries are preserved now.
- SQL Formatting Options frames are added to the Full-Featured MDI demos.

December 31, 2019

Active Query Builder 3 WPF Edition v.

+ SAP Hana & ANSI Standard SQL Syntax: Support for the standard 
  TRIM(LEADING/TRAILING ...) builtin function is added.
- Oracle: The bug with loading objects from the PUBLIC schema is fixed.
- Oracle: Paging using the ROWNUM function in Oracle 11g and lower is fixed.
- MySQL: Parsing of the MATCH full-text search expression is fixed.

December 13, 2019

Active Query Builder 3 WPF Edition v.

= The new helper method QueryColumnListItem.CreateAliasIdentifier has been 
  added to get a column name from the alias.
- The Null Reference Exception on loading OR conditions with brackets has
  been eliminated.
- Auto Syntax Provider: The Null Reference Exception on disposing of
  referencing objects has been fixed.
- Quotation of aliases and other identifiers with alternate quotation
  symbols has been corrected.
- The bug with adding HAVING conditions using the
  QueryColumnList.AddCondition helper has been fixed.

November 22, 2019

Active Query Builder 3 WPF Edition v.

= Query Columns List: Handling of incomplete strings in expression cells has 
  been improved.
= The missing method ISqlTextEditor.GetOffsetFromPoint has been restored.
= New helper method has been made to add conditions to WHERE or HAVING:
  UnionSubQuery.QueryColumnList.AddCondition(ConditionType conditionType, 
  string condition).
- PostgreSQL: Support for WITH clause in subqueries has been added.
- MS SQL Server: Parsing of ordinal named parameters ("@0") has been restored.

Product Summary

 Active Query Builder WinForms .NET Edition:

 Active Query Builder WPF .NET Edition:

 Active Query Builder ASP.NET Edition:

 Active Query Builder Java Edition:

 Active Query Builder ActiveX Edition:

 Active Query Builder VCL Edition:



We have been using Active Query Builder for over a year and must say that both the product and support have been outstanding!

We chose Active Query Builder due to its flexibility and features, but have been truly pleased by its power and hidden capabilities. ...

In summary Active Query Builder provides excellent components, great support and a very flexible feature set. It has allowed us to provide features to our end users that I did not think would be possible in the first release of our new tools and in a timeframe that was much shorter than planned. I would recommend that anyone dealing with databases in the .Net world should be aware of this component and its capabilities!

Social networks