Downloads

Active Query Builder History History

June 26, 2019

Active Query Builder History v.3.5.21.1134

- QueryTransformer: The bug with the double expansion of virtual objects 
  has been fixed.
- SQL Anywhere: The load of remarks for tables has been fixed, the usage 
  of restricted system views has been avoided, temporary tables are loaded 
  correctly now.

June 03, 2019

Active Query Builder History v.3.4.6

+ "Query Results" demo has been added to JavaScript demo projects for
  Classic ASP.NET and ASP.NET Core.
- Minor synchronization issues for operations with datasources performed 
  right after switching to another sub-query have been fixed.
- The bug with serializing the state of the Query Columns Grid in XML layout 
  has been fixed. This led to problems working with a custom state storage 
  provider relying on the query model serialization.
= Error handling on initializing the component via the configuration file 
  has been improved.
- The bug with displaying of primary key icons has been fixed.
- The bug with removing of a CTE sub-query currently displayed on the Design 
  Pane has been fixed.

June 02, 2019

Active Query Builder History v.3.5.20.1133

+ MySQL: Support for window functions and WINDOW clause have been added.
+ PostgreSQL: Support for window functions and WINDOW clause have been added.
= Serialization of the Query Column List to the LayoutSQL has been improved.
- Subquery Navigation Popup closing after a click on the SELECT button has
  been fixed.

June 02, 2019

Active Query Builder History v.3.5.20.1133

+ MySQL: Support for window functions and WINDOW clause have been added.
+ PostgreSQL: Support for window functions and WINDOW clause have been added.
= Serialization of the Query Column List to the LayoutSQL has been improved.

June 02, 2019

Active Query Builder History v.3.5.20.1133

+ MySQL: Support for window functions and WINDOW clause have been added.
+ PostgreSQL: Support for window functions and WINDOW clause have been added.
= Serialization of the Query Column List to the LayoutSQL has been improved.

May 28, 2019

Active Query Builder History v.3.5.19.1132

- The bug with applying localization to the columns of the Query Columns
  Grid has been fixed.
! We highly recommend removing the following values stored in ".Designer.cs"
  files if you didn't redefine column captions using these properties:
  this.queryBuilder1.QueryColumnListOptions.ColumnsOptions.*Column.Caption

May 28, 2019

Active Query Builder History v.3.5.19.1132

- The bug with applying localization to the columns of the Query Columns
  Grid has been fixed.
! We highly recommend removing the following values stored in ".Designer.cs"
  files if you didn't redefine column captions using these properties:
  this.queryBuilder1.QueryColumnListOptions.ColumnsOptions.*Column.Caption

May 25, 2019

Active Query Builder History v.3.4.5

= Status bar can be closed manually now.
+ The new VerifyingQueryElements demo has been added to illustrate preserving
  of specific query parts despite the user's intention to remove them.
+ New server-side events have been added to the QueryBuilder class: 
  QueryColumnListItemAdding, QueryColumnListItemChanging, 
  QueryColumnListItemRemoving, DataSourceAdding, DataSourceRemoving,
  DataSourceFieldAdding, DataSourceFieldRemoving, LinkRemoving, LinkCreating,
  LinkChanging.
+ GridComponent.Events.GridOnReload client event has been added.
+ The '-ing' QueryBuilder client events can now be used to abort user actions:
  DataSourceFieldAdding, DataSourceFieldRemoving, DataSourceDeleting.
- The bug with loading child items of custom Metadata Structure nodes has been
  fixed.
- The grid.findRowsByExpression method changed, used strict expression 
  comparison instead.

May 25, 2019

Active Query Builder History v.3.5.18.1130

+ Farsi (Iranian) localization has been added.
  -- Thanks to M. Abbasi!
= Oracle: Missing PL/SQL keywords have been added to the list of suggestions.
- The bug with the Oracle metadata loading form has been fixed.
- Trial version: The QueryTransformer in the trial mode (with random aliases)
  works correctly now.

May 25, 2019

Active Query Builder History v.3.5.18.1130

+ Farsi (Iranian) localization has been added.
  -- Thanks to M. Abbasi!
= Oracle: Missing PL/SQL keywords have been added to the list of suggestions.
- The bug with the Oracle metadata loading form has been fixed.
- Trial version: The QueryTransformer in the trial mode (with random aliases)
  works correctly 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:

News

Tweets

Testimonials

We have been using Active Query Builder for over a year and must say that both the product and support have been outstanding!

We chose Active Query Builder due to its flexibility and features, but have been truly pleased by its power and hidden capabilities. ...

In summary Active Query Builder provides excellent components, great support and a very flexible feature set. It has allowed us to provide features to our end users that I did not think would be possible in the first release of our new tools and in a timeframe that was much shorter than planned. I would recommend that anyone dealing with databases in the .Net world should be aware of this component and its capabilities!


Social networks