Downloads

Active Query Builder History History

September 30, 2021

Active Query Builder History v.1.31.0

+ Now it's possible to filter fields in datasources on the Design Pane.
+ Informix: Support for databases, double-quoted strings, curly-braced 
  comments are added; the keywords list is updated.
= MySQL: ANSI_QUOTES server option autodetection is made.
- The crash on adding CTE in some cases has been eliminated.

September 22, 2021

Active Query Builder History v.3.8.10.2208

+ The new property is added to determine the case of built-in functions and
  variables: SQLGenerationOptions.BuiltinFormat.
= Design Pane: In the field list context menu, the Sorting item is moved to
  the root of the menu, the HAVING item is shown if a query has grouping.
= The SQLFormattingOptions.KeywordFormat property is moved to the
  SQLGenerationOptions class.
= IBM DB2, Informix: Metadata providers are compiled in the AnyCPU mode.
  Make sure that you have the required version of the DB client installed.
= Syntax provider settings forms: The 'Deny INTO clause' option is not shown
  anymore.
- Minor UI fixes are made.

September 22, 2021

Active Query Builder History v.3.8.10.2208

+ The new property is added to determine the case of built-in functions and
  variables: SQLGenerationOptions.BuiltinFormat.
= Design Pane: In the field list context menu, the Sorting item is moved to
  the root of the menu, the HAVING item is shown if a query has grouping.
= The SQLFormattingOptions.KeywordFormat property is moved to the
  SQLGenerationOptions class.
= IBM DB2, Informix: Metadata providers are compiled in the AnyCPU mode.
  Make sure that you have the required version of the DB client installed.
= Syntax provider settings forms: The 'Deny INTO clause' option is not shown
  anymore.

September 22, 2021

Active Query Builder History v.3.8.10.2208

+ The new property is added to determine the case of built-in functions and
  variables: SQLGenerationOptions.BuiltinFormat.
= The SQLFormattingOptions.KeywordFormat property is moved to the
  SQLGenerationOptions class.
= IBM DB2, Informix: Metadata providers are compiled in the AnyCPU mode.
  Make sure that you have the required version of the DB client installed.

August 31, 2021

Active Query Builder History v.3.8.9.2207

= Code refactorings are made.

August 31, 2021

Active Query Builder History v.3.8.9.2207

= The field context menu in DataSource controls on the Design Pane has been
  improved when grouping is applied, and the field is used in the query
  several times.
- The field sorting icon is fixed in DataSource controls on the Design Pane
  when the field is mentioned in the ORDER BY several times.
- SQL Text Editor: Search and replace functionality has been fixed.
- SQL Text Editor: Pressing the Ctrl+Backspace key combination removes the
  whole word at the left of the cursor. The Shift+Backspace now acts as the
  Backspace key.

August 31, 2021

Active Query Builder History v.3.8.9.2207

= The field context menu in DataSource controls on the Design Pane has been
  improved when grouping is applied, and the field is used in the query
  several times.
- The field sorting icon is fixed in DataSource controls on the Design Pane
  when the field is mentioned in the ORDER BY several times.
- SQL Text Editor: Search and replace functionality has been fixed.
- SQL Text Editor: Pressing the Ctrl+Backspace key combination removes the
  whole word at the left of the cursor. The Shift+Backspace now acts as the
  Backspace key.

August 31, 2021

Active Query Builder History v.3.8.9.445

= The QueryBuilder.DataSourceField(Adding/Added/Removing/Removed) events are
  fired correctly now.
= The new QueryBuilder.Clear() method is added.
- The datasource linked objects context menu now displays alternate names if
  they are defined.
= References to ActiveQueryBuilder.Core assemblies were updated.

August 13, 2021

Active Query Builder History v.3.8.8.2206

- The bug with SQL text generation for objects and fields with empty 
  alternate names when the UseAltNames property is true has been fixed.

August 13, 2021

Active Query Builder History v.3.8.8.2206

= Design Pane diagram painting has been speeded up.
= GrapeCity reports module can be activated in the Full-Featured MDI Demo 
  by turning on the EnableActiveReportsSupport property in the Samples\
  Directory.Build.props file. 
- The keyboard arrow-keys navigation in the Query Column List (move left in
  the Criteria column) has been fixed. 
- The bug with SQL text generation for objects and fields with empty 
  alternate names when the UseAltNames property is true has been fixed.

scroll to top
© Copyright 2005-2022 ActiveDBSoft. All rights reserved.
Site Map Terms of Use Privacy Policy

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