Downloads

Active Query Builder History History

December 14, 2020

Active Query Builder History v.3.7.7.1182

+ The new property MetadataItem.Visible is added to hide some objects and 
  fields in UI.
+ The new bool property MetadataField.DisplayInLookup is added to mark fields
  that should be displayed to identify a record in lookup controls.
+ The new list property MetadataField.EnumValues is added to ease the 
  selection of enum-coded values.
= Metadata Container Editor: Metadata loading improvements are made.
= Azure SQL: Fetching field descriptions has been added.
- String aliases in subqueries are fixed.
- QueryTransformer: The bug with loading columns with case-sensitive names
  is fixed.

December 01, 2020

Active Query Builder History v.2.10.22.833

= Informix: Support for the LIMIT clause is added.
- Generic SQL syntax: Support for ABS built-in function is added.
- Oracle: The bug with parsing names containing the PACKAGE component is
  fixed.
- MySQL: The bug with the special syntax of POSITION has been fixed.

December 01, 2020

Active Query Builder History v.2.14.4

= Informix: Support for the LIMIT clause is added.
- Generic SQL syntax: Support for ABS built-in function is added.
- Oracle: The bug with parsing names containing the PACKAGE component is
  fixed.
- MySQL: The bug with the special syntax of POSITION has been fixed.

November 25, 2020

Active Query Builder History v.3.7.6.1181

+ Two methods are added to save and restore widths of columns set by the
  user: QueryBuilder.QueryColumnListControl.SaveLayout and RestoreLayout.
- Query properties dialog incorrect behavior when the wrong expression
  is set for the TOP clause has been fixed. 
= It is now always possible to change the PERCENT and WITH TIES options 
  even if the TOP clause is not defined.
= Informix: Support for the LIMIT clause is added.
- Generic SQL syntax: Support for ABS built-in function is added.
- Minor parsing errors are fixed.
- Oracle: The bug with parsing names containing the PACKAGE component is
  fixed.

November 25, 2020

Active Query Builder History v.3.7.6.1181

+ Two methods are added to save and restore widths of columns set by the 
  user: QueryBuilder.QueryColumnListControl.SaveLayout and RestoreLayout.
+ It is now always possible to change the PERCENT and WITH TIES options 
  even if the TOP clause is not defined.
= References to DevExpress assemblies are updated to v.20.2.
= Informix: Support for the LIMIT clause is added.
- Generic SQL syntax: Support for ABS built-in function is added.
- Minor parsing errors are fixed.
- Oracle: The bug with parsing names containing the PACKAGE component is
  fixed.
- DevExpress: The Add Object dialog is fixed.
- Add Object Dialog: Slow loading of tables and views is fixed. 

November 25, 2020

Active Query Builder History v.3.7.6.1181

= Informix: Support for the LIMIT clause is added.
- Generic SQL syntax: Support for ABS built-in function is added.
- Minor parsing errors are fixed.
- Oracle: The bug with parsing names containing the PACKAGE component is
  fixed.

November 25, 2020

Active Query Builder History v.3.7.6.424

+ Client-side QueryBuilder.loadStyleFrom property is added to override the 
  CSS completely.
+ Server-side and client-side CriteriaBuilder.LoadStyleFrom properties are 
  added to override the CSS completely.
- We now use the ConcurrentDictionary instead of Dictionary for storing 
  QueryBuilder and QueryTransformer instances server-side.
- Quotation of objects in expressions created on double clicks on 
  datasource fields has been fixed.
- The ObjectTreeView.DefaultExpandFolderNodes property has been fixed.

October 28, 2020

Active Query Builder History v.3.7.5.1179

+ OLE DB, Sybase and Informix metadata providers are added for .NET Core.
- DevExpress: Compilation from the source code has been fixed.
- The addition of rows in the Query Column List by keyboard has been fixed.

October 28, 2020

Active Query Builder History v.3.7.5.1179

+ OLE DB, Sybase and Informix metadata providers are added for .NET Core.
- The selection of rows in the Query Column List has been fixed.

October 28, 2020

Active Query Builder History v.3.7.5.1179

+ OLE DB, Sybase and Informix metadata providers are added for .NET Core.

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