Downloads

Active Query Builder History History

December 15, 2015

Active Query Builder History v.2.10.5.752

+ Oracle: implemented data type computation in expressions.
= Recognition of IN clauses and date literals in expressions is improved.
- ODBC literals and function call syntax are fixed in all syntax providers.
- PostgreSQL: Support of UESCAPE in unicode string literals is added.
- Oracle: Support for ListAgg and XmlAgg in analytic expressions is added.
- MS SQL Server: Added date parts to the list of valid identifiers.
= ValidateQuery() now throws exception if SELECT list is empty.

December 15, 2015

Active Query Builder History v.3.0.1.1003

+ Data type computation in expressions is made for Oracle.
= Recognition of date and string literals, and lists of literals in the 
  IN clause is improved for Criteria columns.
- ODBC literals and function call syntax is fixed in all syntax providers.
- PostgreSQL: UESCAPE support in unicode string literals is fixed.
- Oracle: Support for ListAgg and XmlAgg in analytic expressions is fixed.
- MS SQL Server: Date parts are added to the list of valid identifiers.
= The ValidateQuery() method now throws exception if SELECT list is empty.

December 15, 2015

Active Query Builder History v.3.0.1.1003

+ Data type computation in expressions is made for Oracle.
= Recognition of date and string literals, and lists of literals in the 
  IN clause is improved for Criteria columns.
- ODBC literals and function call syntax is fixed in all syntax providers.
- PostgreSQL: UESCAPE support in unicode string literals is fixed.
- Oracle: Support for ListAgg and XmlAgg in analytic expressions is fixed.
- MS SQL Server: Date parts are added to the list of valid identifiers.
= The ValidateQuery() method now throws exception if SELECT list is empty.

December 11, 2015

Active Query Builder History v.3.0.0.1002

= First public BETA version.

December 11, 2015

Active Query Builder History v.3.0.0.1002

= First public BETA version.

December 10, 2015

Active Query Builder History v.1.26.6

- Minor fixes in the Metadata Container Editor and Loader forms are made.

December 10, 2015

Active Query Builder History v.1.26.6

- Minor fixes in the Metadata Container Editor and Loader forms are made.
- DevExpress forms are fixed.

December 09, 2015

Active Query Builder History v.1.26.5

+ MS Access: Support for CONVERT builtin function is made.
+ PostgreSQL: Support for POSITION builtin function is made.
- Oracle: PRECISION, NULLS, TIME, READ, INTERVAL are treated as valid
  identifiers now.
- Oracle: The "List index out of bounds" error in data type calculation is
  fixed.

December 09, 2015

Active Query Builder History v.1.26.5

+ MS Access: Support for CONVERT builtin function is made.
+ PostgreSQL: Support for POSITION builtin function is made.
= Help file is converted to CHM format.
- Oracle: PRECISION, NULLS, TIME, READ, INTERVAL are treated as valid
  identifiers now.
- Null reference exception is fixed thanks to passing MetadataFilter and
  Database to the metadata loading thread in the LoadMetadataAsync method.
- Oracle: The "List index out of bounds" error in data type calculation is
  fixed.
- Access violation in the TacBaseMetadataProvider.ExecSqlInternal method
  is eliminated.
- Minor DevExpress forms fixes are made.

December 07, 2015

Active Query Builder History v.1.26.4

+ Polish translation is added.
+ Oracle: Calculation of SQL expression data types is made.
- Better "IN" lists and date literal recognition in the select list is made.
- MS SQL Server: Date parts are added to the list of valid identifiers.
+ The new SyntaxProvider.IsQueryWithIntoClause method is implemented for
  MS Access, MS SQL Server, PosgreSQL, and MySQL.
- ODBC "fn" call is fixed.
+ Logging of user actions is possible now.

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