Downloads

Active Query Builder ActiveX Edition History

May 27, 2014

Active Query Builder ActiveX Edition v.1.23.6

- MS SQL Server: A workaround for loading metadata via ODBC driver is made.

May 13, 2014

Active Query Builder ActiveX Edition v.1.23.4

= Small improvements in asyncronous SQL execution are made. 
= Demo projects: The RefreshMetadata method call after Connect is removed, 
  as it is called automatically on connect.

May 07, 2014

Active Query Builder ActiveX Edition v.1.23.3

= 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 ActiveX Edition v.1.23.2

- Prevent races on RefreshMetadataAsync and RefreshMetadata calls.
- Minor fixes in the Query Transformer are made.

April 29, 2014

Active Query Builder ActiveX Edition v.1.23.1

- Installer: Fixed problem with registration of the main OCX.
- 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 ActiveX Edition v.1.23.0

+ 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 ActiveX Edition v.1.22.8

+ Add Linked Objects menu: Separate menu items are show now if there are many
  links for a linked object.
- MS SQL Server: Parsing of method calls is fixed.

January 25, 2014

Active Query Builder ActiveX 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 ActiveX Edition v.1.22.6

= Windows 2000 compatible version is added to the "Compat" folder.
= 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.
= 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 13, 2013

Active Query Builder ActiveX 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.
- Access Violation error when using miltiple Query Builders with ODBC 
  connection string is fixed.