Active Query Builder VCL and ActiveX Editions 1.24 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.24?
VCL Edition: Support for RAD Studio XE7 is added.
Behavior and API changes:
Datasource is now focused on mouse hover to display the linked objects button; "No linked objects" menu item is shown if linked ojbects are not found.
Parametrized queries are used now to fetch fields list for MS SQL Server and Oracle to reduce the load on the server when retrieving metadata.
The new SelectListOptions.ResolveColumnNamingConflictsAutomatically property is added to instruct the component to generate unique aliases for explicitly specified query columns to avoid duplicated column names.
Case-insensetive comparison is used now for unique aliases generation.
VCL Edition:
Syntax Providers: The new set of functions to pack/unpack date, time and timestamp literals are added.
The new internal metadata loading interfaces with directly specified database connection are made.
TacSubQuery.SQL and TacUnionSubQuery.SQL properties now accept empty strings.
The "Preload Metadata Container" design-time command is re-enabled.
Query Transformer: SortedColumn.SortType property setter is added to allow changing of sort order.
Query Transformer: Other improvements and bugfixes are made.
TacQueryTransformer objects can be assigned now.
SQL Syntax improvmements and fixes:
MS SQL Server: Support for new analytic functions SQL Server 2012 is made.
Oracle: SearchClause and CycleClause in WithClauseItems is supported.
PostgreSQL: RECURSIVE keyword in WITH clause support is added.
MS Access: It is possible to parenthesize complex join expressions as it's necessary when working with MS Excel.
MS Access: Backtick-quoted identifiers are accepted now. They will be converted to square brackets during the query generation.
MySQL: Quoted characters in string literals are supported now.
Firebird: WEEK date part support is added.
Universal syntax: Query properties form to add DISTINCT clause is added, list of reserved words is extended.
OLE DB connection: Forced to sort list of fields by ordinal position.
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!