Active Query Builder VCL and ActiveX Editions 1.25 are released.
We're glad to announce the new minor version of Active Query Builder. You can evaluate the new version by requesting the trial. Customers can download the new version in the Customer's area.
What's new in the Active Query Builder version 1.25?
VCL Edition:
Support for RAD Studio XE8 is added.
Compatibility with VCL Styles is improved.
Major changes:
Fonts scaling support is made.
Support of RTL languages is improved.
Ability to select muptiple rows in the Query Columns Grid eases query columns re-ordering.
Pack of changes to allow for independent sub-query SQL text editing is made (see below).
The Aggregate column of the Query Columns Grid is moved closer to the Grouping column.
VCL Edition: Support for database connection activity logging is made.
VCL Edition: The new Sub-query Results Preview demo is added to illustrate working with subqueries independently and using the Query Transformer API.
Behavior changes:
Focus is not moved on mouse hover over datasources on the Design pane if the component is not focused.
Column aliases entered in the Query column list are always quoted now to preserve the case.
Query columns list height and columns width are preserved now after parsing of updated SQL query text.
SQL Syntax improvmements and fixes:
Support for connectivity with NexusDB v.4 is made.
Support for AdvantageDB SQL syntax is made.
PostgreSQL: LIKE (ANY|SOME|ALL) is supported now.
SQLite: Support for Common Table Expressions and backtick quoted identifiers is made.
ANSI SQL/2003: Using the TABLE wrapper for stored procedures in FROM is possible now.
MySQL: Support for CHAR builtin function is made.
API changes:
The new property SelectListOptions.CreateColumnAliasesForUnnamedColumns is added to instruct the component to add aliases for unnamed fields (expressions, aggregates) automatically. It is turned on by default.
The new AlwaysWrapInSubQuery property is added to TacQueryTransformer to instruct the component to wrap original query in sub-query even it is not necessary in order to perform the requested modifications.
The new QueryBuilder.OnSelectListColumnWidthsChanged is made. Helpers to get/set columns widths are added.
The OnActiveSubQueryChanging and OnActiveUnionSubQueryChanging events signatures are changed. Now you can deny sub-query changing.
The TacSubQuery.SetSql method now accepts CTE for the main query.
The TacUnionSubQuery.SQL property now emits empty string for empty queries.
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!