Below is the list of fixes and improvements in Active Query Builder VCL Edition v.1.28.8.
+ Initial support of SAP Hana SQL syntax has been added. = Oracle: Support for the new Oracle 12c LISTAGG syntax has been added. = Pervasive: List of keywords and functions has been filled. = Pervasive: Support of IF function, LIMIT/OFFSET clause has been made. - Pervasive: Parsing of date/time builtin functions has been fixed. - Teradata: The bug with the autodetection of new versions has been fixed. - SQLite: Parsing of queries with RIGHT and FULL joins throws the parsing exception now. - IBM DB2: NULL is parsed as a constant, not as an identifier. = The new limitation of the trial edition: generation of random aliases for the query output columns. + The new method TacSubQuery.GetSqlForDataPreview() returns correct SQL query to preview the sub-query result data. = The LinkOptions.CreateLinksByIdenticalFieldNames behaviour has been changed. Links are created only if one of the fields is a part of the primary key. = FireDAC: Loading of Primary Key fields has been improved. = Complex SQL expressions aren't loaded as joins anymore. - Changing of the link type if RIGHT JOIN is not supported is not allowed now. - The bug with the height calculation of the UNION navigation bar when the query has unions in brackets has been fixed. - Memory leaks have been eliminated.
[ 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!