Downloads

Active Query Builder History History

March 21, 2017

Active Query Builder History v.3.3.3.1039

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

March 17, 2017

Active Query Builder History v.1.26.35

+ SQLite: Right outer joins are converted to left now.
= SQLite: Non-qualified double-quoted identifiers are treated as strings now.
- MS SQL Server: Built-in @@-named variables are recognized now.
- Oracle: Date/time built-in constants are recognized properly now.

March 17, 2017

Active Query Builder History v.2.10.6.806

+ SQLite: Support for the IS operator ("expr IS expr") has been added.
+ 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.
= Automatic links creation for self-linked objects has been improved.
  (from Parent to Child or Child to Parent, not both)
= Constant expressions aren't appended to the grouping list now.
= Default namespace prefixes aren't skipped in the Database Schema Tree now.
= Better unique table alias generation has been made.
= Quoted AltName value is set now by default to the DataSource.NameInQuery
  property.
- MS SQL Server: Built-in @@-named variables are recognized now.
- Oracle: Date/time built-in constants are recognized properly now.
- MS SQL Server: DATEPART parser ambiguity has been fixed.

March 17, 2017

Active Query Builder History v.3.3.2.1038

+ Installer: Integration with Visual Studio 2017 has been added.
= 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.
= Constant expressions aren't appended to the grouping list now.

March 17, 2017

Active Query Builder History v.3.3.2.1038

+ Installer: Integration with Visual Studio 2017 has been added.
+ The new group of properties has been added to control properties of
  particular columns of the Query Columns Grid:
  QueryColumnListControl.GridColumnsOptions,
  QueryBuilder.QueryColumnListOptions.ColumnsOptions. 
  This group contains a set of the following properties for each column in
  the grid: ExpressionColumn, AliasColumn, SortTypeColumn, SortOrderColumn,
  AggregateColumn, GroupingColumn, ConditionTypeColumn, CriteriaColumn.
  With these properties it is possible to change the order of columns in the 
  grid (Index), their visibility (Visible), header captions (Caption), get
  and set the width (Width) and specify auto sizing mode (AutoSizeMode).
= The QueryBuilder.QueryColumnListOptions.ColumnWidths group of properties
  is obsolete now.
= 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.
- The View.Winforms.DevExpress assembly doesn't refer now to the
  View.Winforms assembly.
- 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.

March 17, 2017

Active Query Builder History 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 17, 2017

Active Query Builder History v.2.13.7

= Constant expressions aren't appended to the grouping list now.
- The cross-origin IFRAME access problem has been eliminated.
- The bug with displaying alternate names in dynamic tree structure while
  setting them during the construction of the tree has been fixed.

March 17, 2017

Active Query Builder History v.1.26.35

+ SQLite: Right outer joins are converted to left now.
= SQLite: Non-qualified double-quoted identifiers are treated as strings now.
= The OnSQLUpdated event doesn't fire now during the form load.
- MS SQL Server: Built-in @@-named variables are recognized now.
- Oracle: Date/time built-in constants are recognized properly now.

March 15, 2017

Active Query Builder History v.2.13.6

= Default prefixes aren't skipped now in item captions in the Database
  Schema View.
+ The new demo illustrating toggling of the UseAltNames property has been
  added for MVC 5 and Non-MVC (ToggleUseAltNames).
- The bug with resizing of Design Area in IE11 has been fixed.
- The 500 Server error on parsing a query with complex join expression has
  been fixed.

March 13, 2017

Active Query Builder History v.1.26.34

= Automatic links creation has been improved: links are created only from
  Parent to Child table or vice vera, but not both at the same time.
= The StatisticOutputColumn.ColumnNameInQuery is now quoted if need.
= The StatisticOutputColumn.MetadataField calculation has been improved.
+ The new properties TrimQuotes and TrimSpaces have been added to the
  BaseMetadataProvider class.
= Firing of the ActiveSubQueryChanging/Changed event is enforced on the
  query clearing.
- DevExpress UI: Click on the checkbox in the datasource field list has been
  fixed.
+ 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.
+ IBM DB2: The ListAgg function is supported now.
+ IBM DB2: The QSYS2 tables are used now for fields loading if this scheme
  exists. Several minor bugs have been fixed.
+ SQLite: Support for the IS operator ("expr IS expr") has been added.
- SQLite: The bug with not loading fields for a table being added second to
  the query has been fixed.
- MS SQL Server: loading objects from non-default schemas for non-default
  databases is fixed
- MS SQL Server: The DATEADD parser unambiguity has been fixed.
- MySQL: Parsing of DATE, TIME and DATETIME types as keywords has been
  fixed.