Downloads

Active Query Builder 3 WPF Edition History

February 28, 2020

Active Query Builder 3 WPF Edition v.3.5.38.1156

+ 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
  user.
- 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.3.5.37.1155

+ 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.3.5.36.1154

+ 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.3.5.35.1153

- 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.3.5.34.1152

+ 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.3.5.33.1150

= 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.3.5.32.1149

= 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.

November 11, 2019

Active Query Builder 3 WPF Edition v.3.5.30.1147

= The new helper is made to get the SQL text with custom formatting: The 
  GetSQL(SQLGenerationOptions) method is added to QueryBuilder, SQLQuery, 
  and QueryRoot objects.
= The structure of conditions in the query is preserved better now after 
  the parsing.
= The look and behavior of the MemoEditor control in Properties Bar have
  been improved.
- The UNIQUE keyword is recognized and saved correctly now.

November 01, 2019

Active Query Builder 3 WPF Edition v.3.5.29.1146

- Saved Queries widget: The bug with items deletion has been fixed.
- Full-Featured MDI Demo: Metadata filter editor has been fixed.

October 29, 2019

Active Query Builder 3 WPF Edition v.3.5.28.1145

- The bug with quoted names in "simple" metadata filters has been fixed.