Downloads

Active Query Builder ActiveX Edition History

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.

October 30, 2013

Active Query Builder ActiveX Edition v.1.22.4

= Oracle: Partition OUTER JOIN support is fixed.
= MS SQL Server: Loading of relations is speeded up on SQL Server 2005 and higher.

October 24, 2013

Active Query Builder ActiveX Edition v.1.22.3

+ Alias is printed before expression in the Query Structure Tree.
+ Oracle: National string literals are supported now.
= Oracle: DENSE_RANK in partition clause is supported.
= MS SQL Server: System views are used now to fetch foreign keys 
  (for SQL Server 2005 and newer).
= PostgreSQL: Support of multi-parameter aggregates is made.
- PostgreSQL: Parsing of the ANY clause in codition cells is fixed.

October 10, 2013

Active Query Builder ActiveX Edition v.1.22.2

+ The new IActiveQueryBuilderX.ShowLinkedObjectsButton property is added. 
= Minor improvements in the Add Linked Objects menu are made.
= Default prefixes in object names are skipped now in the Add Linked Objects 
  menu.

October 03, 2013

Active Query Builder ActiveX Edition v.1.22.1

+ MS SQL Server: CLR method calls support is made.
= The linked objects button is placed on the panel now.
= French translation is updated.
- Other bug fixes are made.

October 01, 2013

Active Query Builder ActiveX Edition v.1.22

+ The new button is now shown at the right of the focused datasource on Design
  pane to allow easy adding of linked objects to the query. 
+ The new datasource context menu item is added for the same purpose.
- MS Access: Parsing of the ASC builtin function is fixed.

September 13, 2013

Active Query Builder ActiveX Edition v.1.21.8

= Layout: Horizontal interval between datasources is decreased to 40 px.