Downloads

Active Query Builder History History

June 30, 2021

Active Query Builder History v.1.30.11

+ The initial support for Denodo Virtual Dataport is made.
+ Criteria Builder: Filtration and search with highlighting in the
  suggestion grid is made.
= Criteria Builder: IS (NOT) NULL, and NOT EQUALS operators are allowed for
  boolean field conditions.
= Query Transformer: The fields case is preserved now for a wrapped query.
- Query Transformer: The bug with ORDER BY generation for a wrapped query is
  fixed.
- Automatic generation of short aliases is fixed when the object is added to
  the query from the linked objects menu.
- Metadata object names generation and comparison are fixed when the server
  generally supports schemas, but the server returns an empty schema.
= The generation of SQL query text is made thread-safe.
= Nodes aren't loaded to the metadata tree now if it is hidden.
- The bug with not updating the SQL text on editing a subquery in the link
  expression is fixed.
= MS SQL Server: The support for TRY_CAST and TRY_CONVERT built-in functions
  is added.
= Teradata: A fallback to non-X system views is made if X-views are not
  available.
- Teradata: The server autodetection is fixed.
- Pervasive: Parsing of the IF, DateAdd, DateDiff, and DatePart built-in
  functions and the DOUBLE built-in type are fixed.
- DB2: Parsing of the EXCEPTION JOIN and backslash as a division in
  expressions are fixed.
- SAP Hana: The IsSupportDatabase flag is turned off.

June 30, 2021

Active Query Builder History v.1.30.11

+ The initial support for Denodo Virtual Dataport is made.
= Query Transformer: The fields case is preserved now for a wrapped query.
- Query Transformer: The bug with ORDER BY generation for a wrapped query is
  fixed.
- Automatic generation of short aliases is fixed when the object is added to
  the query from the linked objects menu.
- Metadata object names generation and comparison are fixed when the server
  generally supports schemas, but the server returns an empty schema.
- The bug with not updating the SQL text on editing a subquery in the link
  expression is fixed.
= MS SQL Server: The support for TRY_CAST and TRY_CONVERT built-in functions
  is added.
= Teradata: A fallback to non-X system views is made if X-views are not
  available.
- Teradata: The server autodetection is fixed.
- Pervasive: Parsing of the IF, DateAdd, DateDiff, and DatePart built-in
  functions and the DOUBLE built-in type are fixed.
- DB2: Parsing of the EXCEPTION JOIN and backslash as a division in
  expressions are fixed.
- SAP Hana: The IsSupportDatabase flag is turned off.

June 23, 2021

Active Query Builder History v.3.8.5.441

- Localization fixes are made.

June 23, 2021

Active Query Builder History v.3.8.5.2202

- The bug with empty context lists in Expression Editor is fixed.
- The unhandled exception on opening Expression Editor has been eliminated.

June 23, 2021

Active Query Builder History v.3.8.5.2202

- The bug with empty context lists in Expression Editor is fixed.
- The unhandled exception on opening Expression Editor has been eliminated.
- Visual glitches with the Expression Editor button in the Query Columns List
  were corrected.

June 23, 2021

Active Query Builder History v.3.8.5.2202

= Minor improvements were made.

June 22, 2021

Active Query Builder History v.3.8.4.440

= Minor user interface issues are fixed.
- Lots of issues in Mozilla Firefox are addressed.

June 20, 2021

Active Query Builder History v.3.8.4.2200

- The alignment of links on design pane control has been fixed.
- The execution of pre-compiled demos and the compilation of sample projects 
  have been fixed.
- DevExpress: The unnecessary dependency from System.Resource.Extension assembly
  has been eliminated.

June 20, 2021

Active Query Builder History v.3.8.4.2200

= Minor corrections and code clean-up.

June 12, 2021

Active Query Builder History v.3.8.3.2198

+ Metadata loading wizard has been improved for better synchronization
  between the XML and live database schema.
= Missing localization constants are added.
- The bug with displaying empty Properties Editor after the application load
  has been fixed.
= The default size of SingleLineSqlTextEditor and content alignment has been
  corrected.
- DevExpress: The back color of Query Column List cells has been fixed.
- .NET Core: The alignment of controls in the Properties Editor and Query
  Columns List rows height has been fixed.
- The property editor control for color values has been fixed.
- The location of the Quick Preview Area on Design Pane has been fixed.
= Teradata: The fallback to non-X system views if X-views are not available
  has been made.

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