Downloads

Active Query Builder 3 WPF Edition History

March 17, 2017

Active Query Builder 3 WPF Edition v.3.3.2.1038

+ Installer: Integration with Visual Studio 2017 has been added.
= Default prefixes aren't skipped now in item captions in the Database
  Schema View.
= Oracle: Recognition of built-in constants has been improved.
= MS SQL: Recognition of built-in @@-named variables has been improved.
- The bug with removing of the "TOP n" clause in the query text has been 
  fixed.
- User Queries structure tree isn't reloaded now on every SQL query change.
- Exception on opening the Expression Editor has been fixed.
- The checkbox in the header of the Grouping box works properly now.
- A Query Columns List row is removed now on clearing the value of the
  Expression column.
= Constant expressions aren't appended to the grouping list now.
- The bug with keyboard navigation over the Query Columns List has been
  fixed.
- Links on the Design Pane are cleared properly now on switching between
  sub-queries.

March 06, 2017

Active Query Builder 3 WPF Edition v.3.3.1.1037

+ SQLite: Support for the IS operator ("expr IS expr") has been added.
= Automatic links creation for self-linked objects has been improved.
- The bug with re-applying metadata filters has been fixed.
- Minor bugfixes have been made.

February 27, 2017

Active Query Builder 3 WPF Edition v.3.3.0.1036

+ Now when the user selects the query editing command, the
  UserQueriesView.EditUserQuery event is triggered, in which the developer
  can save the current query before opening the new one, or he can open the
  user query in a new window, the way it's done in the updated Full-featured
  demo project. Also, the events are now fired on deleting, renaming and
  moving user queries between the folders. You can review all API changes 
  in the release notes article.
+ The new helper class Core.UserQueries that consists of static methods has
  been added to perform various manipulations with user queries, such as
  adding, saving, moving, renaming them. It also has the means to save and
  load user queries serialized in XML format.
= The updated Professional Full-Featured demo project illustrates the new
  functionality.
+ The data browsing UI is improved in the Full-featured demo project. 
  It now uses the Query Transformer API to modify SQL queries.
+ The new MetadataLoadingOptions.AllowRecursiveVirtualObjects property
  allows specifying the mode of working with virtual objects. By default,
  referring to other virtual objects in the text of a virtual object is
  allowed. Such reference lets build a chain of objects to break complex
  queries in a series of simple ones. However, in this mode, you can't use
  the same-named physical object in a virtual object because of the emerging
  recursion. Setting this property to false prohibits creation chains of
  virtual objects, but allows to create virtual objects that substitute
  physical database objects.
+ The new SQLite metadata provider has been added.
= The Query Structure demo project has been refactored.
- Removal of unused objects from the query when the 
  QueryBuilder.BehaviorOptions.DeleteUnusedObjects property is turned to
  True has been fixed.

January 27, 2017

Active Query Builder 3 WPF Edition v.3.2.2.1035

+ The new SubQueryBreadcrumbsBar control has been made. It makes quickly
  switch to parent sub-queries.
+ The new ActiveUnionSubQueryChanging event has been added to the QueryView
  and QueryBuilder components. It lets deny switching to another sub-query
  that might be helpful if you let end-users edit the text of sub-queries
  apart from the main query, in the case of the sub-query text parsing
  error.
+ The new SubQueryTextEditingDemo project has been added to Professional 
  and Trial installation packages.
+ IBM DB2: The ListAgg function is supported now.
+ Query Statistics: The UsedDatabaseObjects and UsedDatabaseObjectFields
  collections now include invalid objects and fields being used in the
  query. They differ from valid objects by the absence of MetadataObject
  (for objects) and MetadataField (for fields) references.
= The QueryStructureDemo has been refactored.
- The bug with creating Link controllers has been fixed.
- MS SQL Server: DATEPART parser ambiguity has been fixed.

January 24, 2017

Active Query Builder 3 WPF Edition v.3.2.2.1034

+ The new SQLite metadata provider has been added.
+ Usability of Expression Editor is improved now with the new dockable panels.
+ SQL Text Editor with syntax highlighting is used now to edit joining 
  expression in the Properties bar and dialog.
+ Ability to deny switching to another sub-query has been made. It lets handle
  parsing errors while editing the text of sub-query apart from the main query.
  Handle the ActiveUnionSubQueryChanging event and set the e.Abort parameter 
  to true to deny sub-query changing.
+ Now it's possible to select multiple rows and drag them to reorder columns 
  in the SELECT list.
+ The new Query Structure Demo has been made.
+ PostgreSQL: Support of materialized view, TOAST tables and foreign tables 
  has been made. 
+ Oracle: Support of the "AT TIME ZONE" clause has been added.
+ Firebird: Column name definition after alias in the FROM clause is supported 
  now.
- The bug with not saving the layout of objects after parsing of modified 
  query has been fixed.
- The bug with loading of Query Transformer commands has been fixed.
- Minor fixes in the SQL Text Editor have been made.
- MySQL: Parsing of DATE, TIME, and DATETIME types as keywords has been fixed.

December 22, 2016

Active Query Builder 3 WPF Edition v.3.2.1.1033

= MS SQL Server: Custom aggregates aren't loaded now from linked servers.
- MySQL: Proper fix up of string aliases has been made to avoid control 
  hang on some queries.
- Firing of the SqlTextEditor.TextChanged event has been fixed.
- Crash after clearing some text in the SQL Text Editor in rare cases 
  has been eliminated.
- The SqlTextEditor.Font property has been fixed.
- The property DatabaseSchemaView.ShowFields property has been fixed.
- Saving query along with layout using the QueryView.LayoutSQL property 
  has been fixed.

December 09, 2016

Active Query Builder 3 WPF Edition v.3.2.1.1032

= PostgreSQL Metadata Provider: Reference to Npgsql has been updated.
- Control crash when clearing the text and checking the asterisk item ("*")
  on the table has been fixed.
- Displaying of Varchar(Max) and Varbinary(Max) data types in the datasource
  fields list has been fixed.
= The bug not allowing to use Custom Expression Builder or Expression Editor
  for both the Expression and Criteria columns has been fixed.
- MS SQL Server: List of valid identifiers has been updated.
- SQLite: Support for the string concatenation operator ("||") is fixed.
- Demo projects have been fixed.

November 25, 2016

Active Query Builder 3 WPF Edition v.3.2.1.1031

+ Ability to work with CTE within the Sub-query navigation bar has been made. 
  Users can add, remove, reorder CTE and drag them to the Design Pane.
+ The DISTINCT option has been added to the Properties bar for Generic and
  ANSI SQL dialects.
+ CTE name can be changed now using the Properties bar.
= Double-click on a field in the datasource fields list now leads to the 
  addition of a new unchecked item to the Query Columns List. Focus is moved 
  to the Criteria column to add condition for a newly added item.
= Default configuration of sidebar panels have been changed.
= New labels can be localized now.
- Minor bugfixes and improvements have been made.

October 28, 2016

Active Query Builder 3 WPF Edition v.3.2.0.1030

= Visual improvements for the SQL Text Editor's suggestion window have been
  made.
- The bug with localizing of the "No properties" caption on the Properties
  Bar has been fixed.
- The bug with saving and loading the size of dock panels has been fixed.

October 26, 2016

Active Query Builder 3 WPF Edition v.3.2.0.1029

+ The QueryBuilder control has got the new controls as dockable panels
  located to the left or right of the Design Pane. 
+ The new the Sub-query Navigation Bar has been made. It was formerly
  available as a pop-up window of the Query Navigation Bar. 
  (Available as a separate control in the Professional subscriptions only)
+ Usability of the Sub-query Navigation Bar is improved: now you can change
  the order of union sub-queries using drag'n'drop.
+ The new Properties Bar allows you to set various query, datasource and
  link properties without the need to open a dialog window. 
  (Available as a separate control in the Professional subscriptions only)
+ The new Dock Manager control has been added. 
  (Available in the Professional subscriptions only)
+ The new properties have been added to the PanesConfigurationOptions:
  SubQueryNavBarEnabled, PropertiesBarEnabled, SubQueryNavBarDockOptions,
  PropertiesBarDockOptions. The two latter property groups determine the
  initial state of appropriate sidebar panels and contain the following 
  properties: AutoHide (True/False), Position (Left/Right).
+ The new property QueryBuilder.DockPanelsLayoutXML has been made to save 
  the layout of sidebar panels between work sessions.
+ The new properties have been added to the QueryBuilder.VisualOptions to
  define colors and font of sidebar panels and its docking system.
= The Query, Datasource, and Link Properties dialogs are redesigned.
+ Query Transformer is now capable of renaming output query columns.
+ The new QueryTransformer.RenameDuplicatedColumns property prescribes 
  to explicitly specify all the columns in the query SELECT list by
  expanding the asterisk items, then find and rename the unnamed and 
  duplicated column names (default = false).
+ The new QueryTransformer.AlwaysExpandColumnsInQuery instructs to perform
  asterisk expansion in the query SELECT list even if it's not needed for
  the specified query transformations (default = false).
! The OutputColumn.Name property has been renamed to OriginalName.
! The QueryTransformer.FindColumn method has been replaced with the 
  FindColumnByOriginalName and FindColumnByResultName methods.
+ The new OutputColumn.PreassignedName allows specifying the needed name 
  for a query output column.
+ The new OutputColumn.ResultName gets the result query columns name, which
  turned out as a result of automatic columns renaming routine and manual 
  appliance of the new name specified via the PreassignedName property.
+ Localization in the separate controls mode has been fixed.
= The QueryBuilder.Language and QueryView.Language properties are
  redirected to the ActiveQueryBuilder.Core.Helpers.Localizer.Language
  property.
= Batch query column items processing on grouping on/off has been made.
- QueryTransformer: The bug with incorrect ORDER BY generation if column
  alias is the same as field name has been fixed.
= QueryTransformer: The new SQLGenerationOptions property has been added,
  the SQLBuilder property has been removed.
= The InvalidOperationException is thrown now if both MetadataName and
  MetadataObject properties of the MetadataItem object are specified.
- The bug on resizing QueryColumnList control if cell editor is active has
  been fixed.
- The bug with not displaying fields from derived tables in the Expression
  Editor's tree has been fixed.
+ PostgreSQL: Support of custom aggregate functions has been made.
- MS SQL Server: CHAR and NCHAR, ROW and ROWS are added to the list of 
  valid identifiers.
- Firebird: The simple form of the TRIM function is supported now.
- Oracle: Special form of the TRIM function is supported now.
- Localization in the separate controls mode has been fixed.
= Demo projects are updated and fixed.