Downloads

Active Query Builder 3 WPF Edition History

January 02, 2021

Active Query Builder 3 WPF Edition v.3.7.9.1184

= Minor internal improvements were made.

December 30, 2020

Active Query Builder 3 WPF Edition v.3.7.8.1183

+ The new SqlGenerationOptions.ObjectNamesNormalization property is added
  to instruct the component to normalize object names found in the 
  query according to the database schema.
+ Short aliases for objects added to the query are generated automatically.
  Use BehaviorOptions.GenerateShortObjectAliases property to control this
  behavior.
+ The new panel is added to the top-right corner of the design pane to show or 
  hide unused fields.
- The bug with drag'n'drop of fields on the design pane has been fixed.
- PostgreSQL: PRECISION token is added to the list of valid identifiers.
- DevExpress: SQLTExtEditor default foreground color and font are fixed.

December 14, 2020

Active Query Builder 3 WPF Edition v.3.7.7.1182

+ The new property MetadataItem.Visible is added to hide some objects and 
  fields in UI.
+ The new bool property MetadataField.DisplayInLookup is added to mark fields
  that should be displayed to identify a record in lookup controls.
+ The new list property MetadataField.EnumValues is added to ease the 
  selection of enum-coded values.
= Metadata Container Editor: Metadata loading improvements are made.
= Azure SQL: Fetching field descriptions has been added.
- String aliases in subqueries are fixed
- QueryTransformer: The bug with loading columns with case-sensitive names
  is fixed.

November 25, 2020

Active Query Builder 3 WPF Edition v.3.7.6.1181

+ Two methods are added to save and restore widths of columns set by the
  user: QueryBuilder.QueryColumnListControl.SaveLayout and RestoreLayout.
- Query properties dialog incorrect behavior when the wrong expression
  is set for the TOP clause has been fixed. 
= It is now always possible to change the PERCENT and WITH TIES options 
  even if the TOP clause is not defined.
= Informix: Support for the LIMIT clause is added.
- Generic SQL syntax: Support for ABS built-in function is added.
- Minor parsing errors are fixed.
- Oracle: The bug with parsing names containing the PACKAGE component is
  fixed.

October 28, 2020

Active Query Builder 3 WPF Edition v.3.7.5.1179

+ OLE DB, Sybase and Informix metadata providers are added for .NET Core.
- The selection of rows in the Query Column List has been fixed.

October 22, 2020

Active Query Builder 3 WPF Edition v.3.7.4.1177

+ Reports generation has been added to the Full-featured MDI demo for
  StimulSoft, ActiveReports, and FastReport.
= Properties forms look better now.
= Invariant culture is used for SQL tokens case conversion.

October 13, 2020

Active Query Builder 3 WPF Edition v.3.7.3.1176

= SQL query loading and query statistics calculation have been speeded up.
= Oracle: Schema list loading has been speeded up.
+ PostgreSQL: Support for parenthesized subqueries has been added.
= Query Transformer: Queries with DISTINCT aren't wrapped in a subquery now 
  if the WHERE clause is empty.
- The bug with showing UserQuery fields in the Database Schema Tree after the
  search has been fixed.
- Numerous minor user interface bugs were fixed.

September 08, 2020

Active Query Builder 3 WPF Edition v.3.7.2.1175

+ The installer creates local NuGet source with Active Query Builder packages.
- The bug with saving reusable queries has been fixed.
- Minor bugs have been fixed.

August 28, 2020

Active Query Builder 3 WPF Edition v.3.7.1.1174

+ Support for .Net Core 2.2 and 3.1 support has been added.
- Snowflake SQL: LIMIT is treated as a valid identifier now.
- Metadata calculation for virtual objects has been fixed.
- Snowflake SQL: "POSITION" is removed from the keywords list.
- Snowflake SQL: The ambiguity in the parsing of complex comparison 
  expressions has been fixed.

August 21, 2020

Active Query Builder 3 WPF Edition v.3.6.15.1172

= Metadata Editor: Minor error reporting fixes and improvements on
  loading data from XML files have been made.
= Source code of the standard metadata providers (MS SQL Server, OLE DB,
  ODBC) has been added to all distributives.
- Snowflake SQL: Keyword issues have been fixed.
- PostgreSQL: Parsing of "TABLE.*" as a correct AST node at the top level 
  of the SELECT clause has been fixed.
- MySQL: Parsing of the "POSITION" clause has been fixed.