Downloads  »  Active Query Builder VCL Edition History

July 13, 2018

Active Query Builder VCL Edition v.1.28.8

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.

» Full Active Query Builder VCL Edition history