Downloads

Active Query Builder VCL Edition History

May 13, 2014

Active Query Builder VCL Edition v.1.23.4

- Support for NexusDB 3.12 is added.
= Small improvements in asyncronous SQL execution are made. 

May 07, 2014

Active Query Builder VCL Edition v.1.23.3

- Installation for Delphi XE6 is fixed.
= MS Access: Backtick-quoted identifiers are accepted now. They will be converted
  to square brackets during the query generation.

May 06, 2014

Active Query Builder VCL Edition v.1.23.2

- Prevent races on RefreshMetadataAsync and RefreshMetadata calls.
- Installer: RAD Studio XE6 detection is fixed
+ Syntax Providers: The new set of functions to pack/unpack date, time and
  timestamp literals.
= AnyDAC2: Default command timeout is set to 0 (unlimited) instead of 30
  seconds.
- Minor fixes in the Query Transformer are made.

April 29, 2014

Active Query Builder VCL Edition v.1.23.1

- MS SQL Server: Parsing of aggregated functions is fixed.
- DB2: Parsing of Hex, Graphics and Unicode string literals is fixed.
- MS Access: Built-in functions list is fixed.

April 23, 2014

Active Query Builder VCL Edition v.1.23.0

+ RAD Studio XE6 support is added.
+ Connection cloning and asyncronous SQL execution is possible now.
+ Asyncronous metadata loading support is made.
+ MS SQL Server: MS SQL Server 2014 is supported.

- MS SQL Server: method call chain parsing is fixed.
= MS SQL Server: keywords list is updated.
+ PostgreSQL: WITH clause support is made.
= PostgreSQL: The "LIMIT 0" constraint is used for queries to fetch object
  columns (formerly used "LIMIT 1").
+ Oracle: Parsing DATE, TIME and TIMESTAMP literals is fixed.
+ Oracle: Interval expressions are supported now.
= DB2, MySQL, PostgreSQL, ANSI SQL: DATE, TIME and TIMESTAMP literals are
  supported now.
= DB2: Short object names are used in case of SYSTEM naming convention.
- MySQL: DATE and TIME types parsing ambuiguities fixed.

February 25, 2014

Active Query Builder VCL Edition v.1.22.8

+ Add Linked Objects menu: Separate menu items are shown now if there are many
  links for a linked object.
= FireDAC: Zero command timeout can be set now to turn off timing out.
= The AltNameCaseSensitive flag is added to all objects with alternate names.
- MS SQL Server: Parsing of method calls is fixed.

January 25, 2014

Active Query Builder VCL Edition v.1.22.7

= MySQL: The KEY_COLUMN_USAGE is not queried if server version is less than 5.0.
= Firebird: New builtin functions are supported.
= Firebird: Special syntax of TRIM is supported now.
- PostgreSql: Parser ambiguity in ROW expressions is eliminated.
- Focus is not moved to the QueryBuilder anymore on assigning query text to
  the SQL property.

December 19, 2013

Active Query Builder VCL Edition v.1.22.6

= Required stack size for SQL parsing is reduced.
= Custom popup menu is used for all Query Columns Grid cells now.
= The RightToLeft mode is turned off for expressions in the Query Columns Grid. 
- Minor localization updates are made.
- The bug with loading empty string from localization in non-unicode Delphi 
  versions is fixed.
= MS SQL Server: SQL parser is optimized to speed up parsing of deep nested
  function calls.
= MS SQL Server: PARSE is treated as valid identifier now.
- MS SQL Server: Server version autodetection is fixed.
= MS Access: Date/time builtin functions are supported.

November 14, 2013

Active Query Builder VCL Edition v.1.22.5

+ PostgreSQL: The WINDOW clause is supported now.
+ PostgreSQL: The ORDER BY clause in aggregate functions is supported now.
+ PostgreSQL: The ROW constructor expressions are supported now.
+ PostgreSQL: The AT TIME ZONE is supported, the EXTRACT function is updated.
= Linked Objects Menu: Linked object names are sorted alphabetically now.
- Loading of WHERE joins with subqueries referencing other datasources is fixed.

October 30, 2013

Active Query Builder VCL Edition v.1.22.4

- Access Violation in UnionSubQuery.AddObject in non-visual mode is eliminated.
= Sleep Mode and Focusing fixes are made.
= Oracle: Partition OUTER JOIN support is fixed.
= MS SQL Server: Loading of relations is speeded up on SQL Server 2005 and higher.