Downloads

Active Query Builder History History

January 13, 2022

Active Query Builder History v.3.8.15.2217

= Target framework for all C# demos is switched to 4.72. Code clean-up is made.
- Query Transformer: Correct field references in the WHERE clause is generated
  for wrapped queries with the DISTINCT option.
- Informix: Parsing of queries with fields named like keywords is fixed.
- Pervasive DB: The IF builtin function parsing is fixed.

December 09, 2021

Active Query Builder History v.3.8.14.450

+ The QueryTransformer reinitialization after the session expiration is made
  automatic through the respective QueryBuilder initialization handler.
- Query datasources are updated now on the client even if the Canvas is not
  visible at the moment.
= References to ActiveQueryBuilder.Core assemblies are updated.

December 09, 2021

Active Query Builder History v.3.8.14.2212

= HiDPI fixes are made.
= MS SQL Server: Support for the "AT TIME ZONE" clause is made.
- Oracle: The NRE in the code for calculating the expression result type is fixed.
- The positioning of a new datasource control on the Design Pane after adding it
  via the linked datasource field's button is fixed.

December 09, 2021

Active Query Builder History v.3.8.14.2212

= HiDPI fixes are made.
= MS SQL Server: Support for the "AT TIME ZONE" clause is made.
- Oracle: The NRE in the code for calculating the expression result type is fixed.
- Scaling of the UserQueries menu icons is fixed.

December 09, 2021

Active Query Builder History v.3.8.14.2212

= MS SQL Server: Support for the "AT TIME ZONE" clause is made.
- Oracle: The NRE in the code for calculating the expression result type is fixed.

December 08, 2021

Active Query Builder History v.1.9.2.1156

= DB2: Support for the EXCEPTION JOIN id added; the backslash is now parsed as 
  a division in expressions.
- The NRE on fixing up some expressions on setting a condition in a grid cell is
  fixed.
- PostgreSQL: The "table.*" expression is accepted as an ordinary row expression
  term now.
= The Non-Visual Demo: minor improvements and code style fixes are made.

November 15, 2021

Active Query Builder History v.2.10.25.836

+ ODBC Metadata Provider: Loading fields using the ODBC GetSchema method is
  implemented.
+ ODBC Metadata Provider: The new SkipLoadFieldsFromGetSchema property is added
  to not use the GetSchema method if its implementation is buggy or slow in 
  some of the ODBC drivers.

November 12, 2021

Active Query Builder History v.3.8.12.448

= References to ActiveQueryBuilder.Core assemblies were updated.

November 11, 2021

Active Query Builder History v.1.31.6

= Design Pane: Datasources don't grab the focus on mouse hover now.
= SQL Text Editor: Gutter width is updated properly on Text Editor font 
  changing. 
= MySQL: Fields are fetched sorted by ORDINAL_POSITION now.
= SQLite: A load of foreign keys is improved.
- Metadata Filter: The exclusion filter condition generation for filter items
  with both non-empty SchemaMask and ObjectMask is fixed.

November 11, 2021

Active Query Builder History v.1.31.6

= Design Pane: Datasources don't grab the focus on mouse hover now.
= MySQL: Fields are fetched sorted by ORDINAL_POSITION now.
= SQLite: A load of foreign keys is improved.
- Metadata Filter: The exclusion filter condition generation for filter items
  with both non-empty SchemaMask and ObjectMask is fixed.

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