Downloads

Active Query Builder 3 WinForms Edition History

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.

July 12, 2020

Active Query Builder 3 WinForms Edition v.3.6.9.1166

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

July 02, 2020

Active Query Builder 3 WinForms Edition v.3.6.7.1165

= The BehaviorOptions.LinkManipulations property is taken into account when
  creating a new link using datasource context menus, notification events are 
  fired correctly then.
= On trying to link a table to itself, a copy of that table is added to the 
  query and linked accordingly.
- The bug with multiline field descriptions drawn on the same line is fixed.

June 26, 2020

Active Query Builder 3 WinForms Edition v.3.6.6.1164

+ Users now can create links from UI separately indicating fields to
  start and finish a new link via the datasource field context menu.
+ Three new events are added to the CriteriaBuilder control:
  NeedEditorForValue, NeedCustomLookupButton, NeedCustomLookupControl.
  They allow for using custom editors for values of specific fields or
  data types.
+ The new demo project CriteriaBuilderCustomize is added to illustrate 
  the way how one can use custom editors, buttons and controls in the 
  CriteriaBuilder control.
+ Source code of the Metadata Container Editor is included in a set of
  demo projects for Trial and Professional versions.
= Criteria Builder: minor fixes and improvements are made.
= QuickBooks: Support for square-brackets quoted identifiers has been added.
- The bug with checking/unchecking an asterisk item in datasources is fixed.

June 10, 2020

Active Query Builder 3 WinForms Edition v.3.6.5.1163

+ Metadata loading errors are displayed now via the notification bar.
+ The new property QueryBuilder.BehaviorOptions.AllowMessageTypes is added 
  to determine the types of messages to be shown in the notification bar.
+ The new property QueryBuilder.DesignPaneOptions.DesignPaneOverviewMaxHeight
  is added to determine the maximum ratio (range from 0 to 1) of the overview
  pane height and overall Design Pane height. 
  The actual width and height of the overview pane is now calculated 
  according to new and DesignPaneOverviewWidth properties.
= QuickBooks (QODBC): Support for the TOP clause is added, support for derived 
  tables is turned off.
= PostgreSQL: Backslash quotation for generic string literals has been removed.
= Metadata serialization to XML: The "Loaded" flag for all types of objects
  is now set on for a namespace if child database objects of any type exist.

June 01, 2020

Active Query Builder 3 WinForms Edition v.3.6.3.1162

= References to DevExpress WinForms controls are updated to v.20.1.3.
+ Initial support for QuickBooks (QODBC) SQL syntax has been added.
+ Performance and memory consumption improvements on loading large database 
  schema has been made.
! "Loaded" flags for object types and referencing foreign keys are saved 
  now in metadata XML files to avoid unnecessary SQL queries to be fired.
= SAP HANA: Minor fixes are made: DISTINCT before TOP, PLACEHOLDER before 
  alias, NVARCHAR builtin type.