Active Query Builder VCL Edition History

December 25, 2015

Active Query Builder VCL Edition v.1.26.9

= Error reporting facility is added to the installer.

December 23, 2015

Active Query Builder VCL Edition v.1.26.8

- The installer is signed using SHA256 algorithm.
- Access violation is fixed in the QueryTransformer.QueryBuilder setter 
  if QueryBuilder doesn't have a SyntaxProvider assigned.
- Metadata provider for AnyDAC v.1: Minor compilation fixes are made.

December 22, 2015

Active Query Builder VCL Edition v.1.26.7

- Installer requires elevation (UAC). 
- Access violation is fixed in the TacSelectItem.SetConditionString method.
- MicroOLAP PostgreDAC compilation warning is fixed.
- Assert on datasource deletion in rare cases for complex queries is fixed.

December 10, 2015

Active Query Builder VCL Edition 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 VCL Edition 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
- Access violation in the TacBaseMetadataProvider.ExecSqlInternal method
  is eliminated.
- Minor DevExpress forms fixes are made.

December 07, 2015

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

November 16, 2015

Active Query Builder VCL Edition v.1.26.3

+ ODBC literals and function calls syntax is supported now in all SQL
- MS SQL Server: YEAR, MONTH and DAY can be used as valid identifiers now, 
  the YEAR builtin function is fixed.
- MS SQL Server: Support for DateAdd function is fixed.
- Oracle: support ListAgg and XmlAgg in analytic expressions
- Oracle: add CYCLE to valid identifiers list
= Advantage DB: Support for Position function is added.
+ PostgreSQL: Support for UESCAPE in unicode string literals is made.
+ The new TacDatasourceObject.ObjectName property is added.
= Condition type column for rows with empty criteria is set now to 
  "for values" in the query columns grid.
- A lot of minor optimizations, improvements and bug fixes are made.

September 18, 2015

Active Query Builder VCL Edition v.1.26.2

+ The new method TacBaseSyntaxProvider.GetKeywords is made to get list of
  reserved keywords.
- MS SQL Server: Support fot IIF function is added.

September 11, 2015

Active Query Builder VCL Edition v.1.26.1

- Netezza: Minor fixes are made.

September 10, 2015

Active Query Builder VCL Edition v.1.26.0

+ Support for RAD Studio 10 Seattle is made.
+ Support for Netezza SQL syntax is added.

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:



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