Active Query Builder 3 WPF Edition History

August 11, 2017

Active Query Builder 3 WPF Edition v.

+ The new IDatabaseSchemaView.ValidateItemContextMenu event has been made.
  It lets customize context menu of the Database Schema Tree items. 
+ The new IDatabaseSchemaView.ExpandItem has been made to expand the tree
  down to the specified item and scroll down to it.
+ Position of an invalid object can be obtained from the SQLParsingException
  on parsing a query when ParsingErrorOnUnknownObjects property is set to
- Crash in the Expression Editor while changing the value has been fixed.
- Drag & drop of objects from the Database Schema Tree to Design Pane has
  been fixed.
- MetadataLoadingOptions.IncludeFilter/ExcludeFilter: filtration by object
  type only has been fixed.
- Caret position on mouse clicking in the TextEditor has been corrected.
- SQL Text Editor: Apostrophes in quoted identifiers don't break the 
  highlighting now.
- The QueryBuilder.LayoutSQL property now accept empty strings without
- Correct column prefix now emitted for UDFs and stored procedures
  without aliases.

July 25, 2017

Active Query Builder 3 WPF Edition v.

+ The new IDatabaseSchemaView.ValidateItemContextMenu event has been added
  to allow the creation of custom context menu for items in the Database 
  Schema Tree. 

July 24, 2017

Active Query Builder 3 WPF Edition v.

= The new property DatabaseSchemaView.Controller has been added.
- The AllowEdit check before the ValidateContextMenu call in the CustomTreeView
  has been removed.

July 19, 2017

Active Query Builder 3 WPF Edition v.

+ PostgreSQL, MySQL, SQLite, Netezza: Support for SQL expressions in the
  LIMIT/OFFSET clauses has been added.
+ The new StreamLog class has been added. It can be used to log the 
  metadata extraction process via the Logger.Log property of SQLConext,
  MetadataProvider and SyntaxProvider objects.
- The bug with registering controls in the Toolbox of Visual Studio 2017 
  has been fixed.
- Moving the popup window of Expression column combo box up and down on
  switching between rows has been eliminated.
- The Expression editor not properly reflecting values of criteria for 
  "OR" columns has been fixed.
- Cells of custom columns of the Query Columns List is refreshed after 
  edit correctly now.
- The bug with collapsing datasource field list after adding a link has 
  been fixed.
- Drag'n'drop is disabled in the Database Schema Tree now.
= Demo projects are grouped by folders in the solution.
= MS SQL Server: List of reserved words has been updated.
- MySQL: The "ORDER BY" clause doesn't eat now in the GROUP_CONCAT window
- Invalid SQL expressions in the Query Columns List are quoted now as
  strings, not as identifiers.

July 05, 2017

Active Query Builder 3 WPF Edition v.

= Demo projects have been updated and fixed.
- Registration of controls in the Visual Studio Toolbar has been fixed.
- The bug with setting focused cell in the Query Columns Grid after changing
  the SQL text has been fixed.
- The bug with Expression editor not reflecting values of conditions
  correctly has been fixed.
- The bug with displaying tables from sub-queries in the main query has
  been fixed.

June 26, 2017

Active Query Builder 3 WPF Edition v.

- Query properties for the main query are displayed correctly now.
- Minor bugs have been fixed.

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. 

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: