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.
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.
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.
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 fixed. - Access violation in the TacBaseMetadataProvider.ExecSqlInternal method is eliminated. - Minor DevExpress forms fixes are made.
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.
Active Query Builder VCL Edition v.1.26.3
+ ODBC literals and function calls syntax is supported now in all SQL syntaxes. - 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.
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.
Active Query Builder VCL Edition v.1.26.1
- Netezza: Minor fixes are made.
Active Query Builder VCL Edition v.1.26.0
+ Support for RAD Studio 10 Seattle is made. + Support for Netezza SQL syntax is added.
Active Query Builder VCL Edition v.1.25.5
- Minor fixes in Interbase Express metadata provider are made.
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!