Downloads

Active Query Builder History History

October 21, 2014

Active Query Builder History v.2.6.0

+ Possibility to show custom Expression Editor for Expression and Criteria
  columns is made. The new demo project is added to illustrate this feature.
= Syncronization actions between client and server are made smoother now.

October 17, 2014

Active Query Builder History v.2.9.0.690

- The bug with hanging on foreign keys loading being connected through 
  the ADO.NET provider which uses non-standart schema column names 
  (like Devart.Data.Oracle provider) is fixed.

October 16, 2014

Active Query Builder History v.2.9.0.689

= DevExpress references are updated to v.14.1.7.0.
- Build error is fixed in the Events Demo project.
- Values for the MetadataField.Size received from server are preferred 
  compared with those obtained from ADO.NET provider.
- MS SQL Server: The DetectServerVersion method isn't called now if
  MetadataProvider.Connection is null.
- Linked Objects menu: Links for foreign keys by multiple fields are
  created correctly now (they were created by the first field only).

October 13, 2014

Active Query Builder History v.2.5.17

- The bug with manual creation of links is fixed.

October 06, 2014

Active Query Builder History v.2.9.0.687

- The bug on calling the QueryBuilder.Clear() in non-visual mode is fixed.
- DevExpress: Sorting in the Database Schema Tree is fixed.
- Query Transformer: The problem with duplicated column names is fixed.

October 03, 2014

Active Query Builder History v.2.5.16

- The bug with loading of datasource fields is fixed.
- Minor datasource layout fixes are made.

October 02, 2014

Active Query Builder History v.2.5.15

+ Performance in IE for the case of datasources with large amount of fields 
  is improved.
- Getter of the QueryBuilderControl.LayoutSQL property is fixed.

September 30, 2014

Active Query Builder History v.2.9.0.685

= Oracle: Expression parsing performance is improved.
- The bug with incorrect column prefix for virtual objects in selected
  columns is fixed.

September 29, 2014

Active Query Builder History v.2.9.0.684

+ The new feature "User Queries" is added to allow for creation of
  reusable virtual objects containing a previously saved query.
+ The new "Reusable Queries" pane is added below the Database Schema Tree.
  Use the PanesConfigurationOptions.UserQueriesPaneVisible property to
  show/hide this pane. To save and load ueser queries use import/export
  methods of the QueryBuilder.UserQueries object.
+ The Show Query By Parts demo is replaced with the improved SubQuery
  Results Preview demo.
+ Query Transformer now supports Skip() with ROW_NUMBER ranking function 
  for DB2 and MS SQL Server 2005-2008.
+ MS Access: Query Transformer is able to use Limit() with MS Access now.
- MS SQL Server: The mistyped DATETIMEOFFSETFROMPARTS function name is 
  corrected.
- DevExpress: Crash on Delete command of the CTE tab context menu is fixed.
- The bug on closing last datasource in CTE is fixed.

September 23, 2014

Active Query Builder History v.2.5.14

+ Sample code of paging and sorting of query result by means of the Query
  Transformer is added into all of the "Query results" sample projects. 
= Union nav. bar maximum width is limited by default.
- The bug with displaying the "0" symbol in Sort Order column is fixed.
- The bug with aggregate column in IE9 is fixed.