Active Query Builder 3 WPF Edition History

October 13, 2017

Active Query Builder 3 WPF Edition v.3.3.22.1069

= Parsing of large Oracle SQL queries has been speeded up.
+ The new Link.ReferencedDataSources property has been added.
+ The new UserQueriesControl.SelectedItemChanged event has been added. 
= Creation of referencing loops of virtual objects is not possible now.
- Drag'n'drop in the User Queries Control has been fixed. 
- The bug with presence of the "empty node" item in folders of the User
  Queries Control has been fixed.
- MySQL: Parsing of DateDiff function has been fixed.
- The bug with localization of the Add Object Dialog has been fixed.
= The new "Execute Query" action has been made in the Full-Featured MDI 
  Demo project.

September 27, 2017

Active Query Builder 3 WPF Edition v.3.3.21.1068

- MySQL: Some valid identifiers were erroneously treated as keywords. 
  Fixed now.
- The bug with selection from the drop-down list of Expression column in 
  the Query Columns List has been fixed.

September 26, 2017

Active Query Builder 3 WPF Edition v.3.3.21.1067

+ PostgreSQL: Support for "$n"-style positional parameters has been added.
- Drop-down editors in the Query Columns List have been fixed.
- Unwanted switch to the main query on adding new sub-query has been fixed.

September 22, 2017

Active Query Builder 3 WPF Edition v.3.3.20.1066

- The bug on loading component with non-empty query inside the Telerik RAD
  panel has been fixed.
- The bug on entering a value to the cell of Query Columns List control 
  that doesn't exist in a combo box suggestion list has been fixed.
- The bug with visibility of the Design Pane Preview area has been fixed.
- The bug with the links remaining on the Design Pane after clearing the
  query has been fixed.
- Oracle: List of keywords used as valid identifiers has been updated.
- MySQL: Support for DateDiff, TimeDiff, TimestampDiff functions has been
  added.
= Methods to save and load user queries to XML have been moved to the 
  SQLContext class.
- Minor bugfixes and improvements have been made.

September 13, 2017

Active Query Builder 3 WPF Edition v.3.3.19.1065

+ The Design Pane Preview area has been made to let quickly navigate over
  large diagrams.
+ The new StatisticsField.IsDirectlyMentioned property has been added. 
  It indicates whether a field is directly mentioned in the query or just
  appears in the query result as a result of the expansion of an asterisk
  item ("*") in the SELECT list.
= User queries structure has been moved from the UserQueries control to 
  the SQLContext.UserQueriesStructure property.
- SQL Text Editor: Word wrapping has been fixed.

August 25, 2017

Active Query Builder 3 WPF Edition v.3.3.18.1065

+ MS SQL Server: Support for SELECT into local variable has been added.
  (SELECT @localVar = ...)
- The bug with resolving baseName.fieldName references for stored procedures
  and table-valued functions has been fixed.
- The bug with not refreshing fields for objects in the main query via 
  RefreshDatasourcesMetadata call has been fixed.
- The bug with not allowing to expand object type grouping nodes (Tables,
  Views, ...) in the Database Schema Tree has been fixed.

August 18, 2017

Active Query Builder 3 WPF Edition v.3.3.17.1064

+ Text Editor: Oracle LISTAGG function template has been added. 
= StreamLog: The underlying stream is flushed now on every write. 
- CriteriaBuilder: Loading conditions with BETWEEN operator for datetime
  columns has been fixed. 
- PostgreSQL: Autodetection has been fixed in the Auto Syntax Provider. 
- Syntax detection process is logged now in the Auto Syntax Provider.

August 11, 2017

Active Query Builder 3 WPF Edition v.3.3.16.1063

+ 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
  True.
- 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
  errors.
- Correct column prefix now emitted for UDFs and stored procedures
  without aliases.

July 25, 2017

Active Query Builder 3 WPF Edition v.3.3.15.1063

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

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

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:

Tweets