Below is the list of fixes and improvements in Active Query Builder VCL Edition v.1.30.8.
+ The component generates short object aliases for objects added to the query if the QueryBuilder.GenerateShortObjectAliases is set to True. = SAP HANA: Support for the CONVERT_UNIT built-in function has been added. = MySQL: Support for UTC_DATE, UTC_TIME, UTC_TIMESTAMP functions has been made. = MySQL: Parsing of the RECURSIVE keyword in the WITH clause has been fixed. = MS Access: Parsing of optional identifier before subquery in the FROM clause has been fixed. = NexusDB: Remote NexusDb server dependencies have been removed from the metadata provider. - Query Transformer: Multi-level filters have been fixed. - Criteria Builder: The bug on pressing the Esc key in the popup list has been fixed. - The Access violation exception on loading complex query with ORDER BY column indices has been eliminated. - PostgreSQL: The PRECISION token has been added to the list of valid identifiers.
[ Legend: ] [ + New feature ] [ = Improved/changed feature ] [ - Bug fix ] [ ! Important notice ]
You can always get the latest trial version of Active Query Builder VCL Edition at the download page.
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!