Downloads

Active Query Builder History History

November 05, 2013

Active Query Builder History v.1.0.6

- The JavaScript error on clicking the Refresh button is fixed.

November 01, 2013

Active Query Builder History v.2.5.4.609

+ Criteria Builder: Filtration of lookup list values by text from the text box 
  is made.
+ XML Documentation files for assemblies are added to the installation package.
= Documentation is updated.
- Expression Editor: The bug with ShowSuggestionAfterCharCount property 
  causing problems in the Form designer is fixed.

October 30, 2013

Active Query Builder History 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 30, 2013

Active Query Builder History 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.

October 29, 2013

Active Query Builder History v.1.6.4.1133

+ Now the Query Builder keeps layout of design pane objects after manual 
  changes of the query text.
- Incorrect bracketing of inner OR in some cases is fixed.
- Oracle: Fixed parsing of PARTITON with OUTER JOIN.
- Oracle: Fixed support for unicode literals (N'abcdef').
- Oracle: Fixed parsing of DENSE_RANK() function.
- MSSQL: Added support for CLR method calls.
- MSSQL: Improved the query for loading foreign keys from server.
- PostgreSQL: Added support for multi-parameter aggregates.
- PostgreSQL: Fixed parsing of ANY in codition cells.

October 28, 2013

Active Query Builder History v.2.5.3.608

- Check boxes painting at non-standard display resolution settings 
  (120 DPI and more) is fixed.

October 25, 2013

Active Query Builder History v.1.19.3.432

+ QueryTransformer now can hide output columns and set the DISTINCT clause.
= MS SQL Server: The query for loading foreign keys from server is improved.
- Oracle: Fixed unicode literals (N'abcdef').
- Oracle: Fixed parsing of the DENSE_RANK() function.
- PostgreSQL: Added support for multi-param aggregates.
- PostgreSQL: Fixed parsing of ANY in codition cells.

October 25, 2013

Active Query Builder History v.2.5.3.607

- The Null Reference exception when clicking datasource object's Close button 
  during the query clearing is fixed.
- Minor fix for custom aggregates support is made.

October 24, 2013

Active Query Builder History 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 24, 2013

Active Query Builder History v.1.22.3

- Installer: Support of Delphi 5 is restored.
+ Query Transformer now can hide output columns and set the DISTINCT clause.
+ 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.
- Query Transformer: Incorrect SQL query generation when source query has 
  the ORDER BY statement is fixed.
- DevExpress: The bug with incorrect datasource position changing when 
  resizing a datasource with a large list of fields is fixed.