Active Query Builder 3 WinForms Edition History

October 13, 2020

Active Query Builder 3 WinForms Edition v.

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

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

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

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

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

August 06, 2020

Active Query Builder 3 WinForms Edition v.

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

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

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

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

July 12, 2020

Active Query Builder 3 WinForms Edition v.

+ Support for Snowflake DB SQL syntax has been added.
+ The SubQuery Navigation Bar now lets you know more about sub-query usage 
  at one sight: query part, operator, correlatedness.
= Searching in the Add Object Dialog is corrected.
= SQL Server: The connection form lets define new authentication options 
  for Azure databases.
- Minor fixes in the Query Columns Grid have been made.
- Assemblies are removed correctly now after uninstalling the product.

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