Active Query Builder VCL Edition v.1.26.15
= MS SQL Server: Parsing performance is improved. - Query Columns List: The fix for "Aggregate" and "Grouping" columns auto-fit is made.
Active Query Builder VCL Edition v.1.26.14
+ The new property is added to the TacCustomExpressionEditorParams object to determine the index of condition/or column: ConditionIndex. + Fitting of the Query Column List's column width on double clicking on the column splitter is made. = Addition or modification of expressions via the OnCustomExpressionEditor event handler now follows the same rules as changing them via the query building UI by end-user. (eg. checking of the Visible field for new rows, assigning aliases to resolve column name conflicts, etc.)
Active Query Builder VCL Edition v.1.26.13
+ The new SQL syntax feature to use aliases in GROUP BY is added: TacBaseSyntaxProvider.IsSupportGroupByAlias property. = Firebird: Domain name is shown now instead of type name in datasource field lists. - Database Schema Tree wasn't scrolled to the top after reload. Fixed now. - The SubQuery.Clear clears the WITH clause as well.
Active Query Builder VCL Edition v.1.26.12
= Design Pane: Aggregated fields are checked now in Datasource controls. - The TAB key behaviour in the last column of Select List is fixed.
Active Query Builder VCL Edition v.1.26.10
+ Query Column List Control now always displays the "Delete item" button. + The new property TSQLBuilderConditionFormat.NewLineBefore is made. + MS SQL: Support for COLLATE clause for column expressions is made. - Access Violation in the "Remove CTE" event handler is eliminated.
Active Query Builder VCL Edition v.1.26.9
= Error reporting facility is added to the installer.
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 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!