Downloads

Active Query Builder 3 WinForms Edition History

October 22, 2020

Active Query Builder 3 WinForms Edition v.3.7.4.1177

+ Reports generation has been added to the Full-featured MDI demo for
  StimulSoft, ActiveReports, and FastReport.
- Hotkeys for row insertion in the Query Column List are corrected.
= Invariant culture is used for SQL tokens case conversion.

October 13, 2020

Active Query Builder 3 WinForms 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 WinForms 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 WinForms 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.
- The drawing of the DockPanel caption in large-scaling modes has been 
  corrected. 
- 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 WinForms 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.

August 11, 2020

Active Query Builder 3 WinForms Edition v.3.6.14.1171

= Snowflake SQL: Support for the "WITHIN GROUP" clause has been added.

August 06, 2020

Active Query Builder 3 WinForms Edition v.3.6.13.1170

- Snowflake SQL: LimitCount and LimitOffset props are turned on to use the 
  Skip and Take methods of the QueryTransformer.

August 05, 2020

Active Query Builder 3 WinForms Edition v.3.6.12.1169

+ The user's job of adding general aggregate functions (with the "*" 
  parameter) has been improved. Now the user can select an aggregate
  function right in the empty row of the Query Columns Grid.
- Snowflake SQL: Parsing of VARCHAR without char count has been fixed.
- SQL parsing error notification panel in the Expression Editor has been
  corrected in large-scaling modes.
- DevExpress UI:  The back color of the edited cell in the Query Columns
  Grid and the SQL Text Editor inside the Expression Editor is applied
  correctly now.
- DevExpress UI: The drop-down button glyph in the Single-line SQL Text
  Editor has been fixed.
- SQL Text Editor now uses the form's back color by default.

August 04, 2020

Active Query Builder 3 WinForms Edition v.3.6.11.1168

+ The new event to track changes in the Favorites folder is added:
  QueryBuilder.FavouritesChanged. (in the Professional version only)
= The new method to append metadata from XML is added:
  MetadataContainer.AddFromXML(filename or stream).
- Snowflake syntax: "LANGUAGE" is removed from the list of keywords.
- Tooltips for fields in datasources on the Design Pane are displayed
  correctly now.
- SAP Hana: Minor SQL generation fixes are made.
- MySQL: Minor fixes for queries with the "~" character.

July 27, 2020

Active Query Builder 3 WinForms Edition v.3.6.10.1167

= ODBCMetadataProvider: new properties are added to turn off some specific
  driver features that sometimes can improve the performance: 
  IgnoreSchemaOnlyFlag and SkipLoadFieldsFromGetSchema.
- MySQL: Logical conditions aren't suffixed with "=True" or "=False" anymore.
- IBM DB2: System views are checked for existence before querying them. 
- Add Object Dialog: The bug in applying the behavior determined by the
  StartWithDefaultNamespaceType property has been fixed.
- Add Object Dialog: The bug on double-clicking the list folders is fixed.