Downloads

Active Query Builder 3 Core Edition History

December 14, 2020

Active Query Builder 3 Core Edition 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.

November 25, 2020

Active Query Builder 3 Core Edition 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.

October 28, 2020

Active Query Builder 3 Core Edition v.3.7.5.1179

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

October 22, 2020

Active Query Builder 3 Core Edition v.3.7.4.1177

= Invariant culture is used for SQL tokens case conversion.

October 13, 2020

Active Query Builder 3 Core Edition v.3.7.3.1176

= SQL query loading and query statistics calculation have been speeded up.
= Oracle: Schema list loading has been speeded up.
+ PostgreSQL: Support for parenthesized subqueries has been added.
= Query Transformer: Queries with DISTINCT aren't wrapped in a subquery now 
  if the WHERE clause is empty.

September 08, 2020

Active Query Builder 3 Core Edition v.3.7.2.1175

+ The installer creates local NuGet source with Active Query Builder packages.

August 28, 2020

Active Query Builder 3 Core Edition v.3.7.1.1174

+ Support for .Net Core 2.2 and 3.1 support has been added.
- Snowflake SQL: LIMIT is treated as a valid identifier now.
- Metadata calculation for virtual objects has been fixed.
- Snowflake SQL: "POSITION" is removed from the keywords list.
- Snowflake SQL: The ambiguity in the parsing of complex comparison 
  expressions has been fixed.

August 21, 2020

Active Query Builder 3 Core Edition v.3.6.15.1172

= Metadata Editor: Minor error reporting fixes and improvements on
  loading data from XML files have been made.
= Source code of the standard metadata providers (MS SQL Server, OLE DB,
  ODBC) has been added to all distributives.
- Snowflake SQL: Keyword issues have been fixed.
- PostgreSQL: Parsing of "TABLE.*" as a correct AST node at the top level 
  of the SELECT clause has been fixed.
- MySQL: Parsing of the "POSITION" clause has been fixed.

August 11, 2020

Active Query Builder 3 Core Edition v.3.6.14.1171

= Snowflake SQL: Support for the "WITHIN GROUP" clause has been added.

August 06, 2020

Active Query Builder 3 Core Edition v.3.6.13.1170

- Snowflake SQL: LimitCount and LimitOffset props are turned on to use the 
  Skip and Take methods of the QueryTransformer.

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