Active Query Builder 3 WPF Edition History

June 23, 2017

Active Query Builder 3 WPF Edition v.

+ SQL Text Editor: The new LoadMetadataOnCodeCompletion property has been
  added. It prescribes to load metadata if it hasn't been loaded yet on
  displaying the suggestion popup list.
! The bug with loading of conditions joined with OR has been fixed.
  They were converted to AND in some cases.
- Query Transformer: The bug on transforming the query with a stored 
  procedure has been fixed.
- Loading of foreign keys has been fixed.
- Other minor bugs have been fixed.

June 16, 2017

Active Query Builder 3 WPF Edition v.

! The bug that caused slow initialization of the component, especially on
  the large database schema has been fixed. 
= The MetadataItem.FindItems(filter, type) method now takes
  the filter.ObjectType property into account.
= MetadataObject.Expression property setter now checks expression for
  recursion loops. 
- The bug with quotation of incorrect SQL expressions with double quotes
  instead of apostrophes has been fixed.
- The exception on double clicking on a datasource has been eliminated.

June 09, 2017

Active Query Builder 3 WPF Edition v.

+ The new events are added to track addition and removal of items in the
  Query Columns List. 
  QueryColumnListControl: ItemAdded and ItemRemoving;
  QueryBuilder: QueryColumnListItemAdded, QueryColumnsListItemRemoving.
- Commands for adding and managing sub-queries in expressions are moved to
  the context menu of appropriate cells. The ellipsis button now immediately
  displays the Expression Editor.
- IBM DB2: Database objects are now loaded from the server if loading from
  driver fails.

June 02, 2017

Active Query Builder 3 WPF Edition v.

- The critical bug with loading of top-level AND conditions has been fixed. 
+ The new DisableQueryNavigationBarPopup property has been added to the
  QueryBuilder.PanesConfigurationOptions group.
+ The new IDatabaseSchemaView.SQLGenerationOptions property has been added
  to alter displaying of object names in the tree. 
+ Database connection logging is possible now.
- Hiding of columns in the Query Transformer hadn't get applied immediately.
  Fixed now. 
- MS SQL Server: Object name is now used as default alias for objects from
  linked servers. 
- The MetadataStructureItem.GetDisplayCaption method has been speeded up.
- Right clicking on the design pane hadn't displayed the menu. Fixed now. 

May 26, 2017

Active Query Builder 3 WPF Edition v.

= Conditions for the same left part joined using the OR operator are merged
  into a single cell now.
= "OR" condition columns in the Query Column List control are created on
  demand now.
- IBM DB2: The method to retrieve the list of schemas now falls back to SQL
  query if loading from driver returns no schemas.
- Referencing objects for User Queries aren't loaded now.

April 28, 2017

Active Query Builder 3 WPF Edition v.

= ODBC Metadata Provider: Better detection of servers that don't support
  schemas has been made.
= SQL 92 Syntax Provider allows empty schema names now.

April 25, 2017

Active Query Builder 3 WPF Edition v.

- The bug with the editing of custom columns in the Query Columns List
  control has been fixed.
= The text of join SQL expression in the Link Properties dialog and sidebar
  panel is wrapped by words now.
- Dependent options in the properties sidebar panel are correctly enabled
  now upon changing the main property.
- The bug with incorrect caret position, when word wrapping is turned on,
  has been fixed.

April 18, 2017

Active Query Builder 3 WPF Edition v.

+ MySQL: Support of MATCH full text search operator has been made.
= IBM DB2: The new DB2SyntaxProvider.ObeySchemaListFromDriver property has
  been added to ensure the priority of the list of objects received from 
  the metadata provider (True by default).
- IBM DB2: The bug with selecting table schema instead of table owner 
  for schema name has been fixed.
- The reference to MySql.Data assembly in MySQL metadata provider has been 
  updated to the version 6.9.9.
- Adorner layer in the QueryColumnListControl has been fixed.

March 24, 2017

Active Query Builder 3 WPF Edition v.

+ Captions on the Criteria Builder UI have been improved.
- WPF: Repeated click on the field with a combobox in the Query Columns List
  cleared the displayed value. Fixed now.

March 21, 2017

Active Query Builder 3 WPF Edition v.

= Database Schema view in the Expression Editor is now grouped by database 
  and schema.
- The bug with grouping database objects by type has been fixed.
- Properties dialogs were inoperable if there's no Properties sidebar on 
  the form. Fixed now.

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: