Active Query Builder ActiveX Edition History

Active Query Builder ActiveX Edition v.1.20.4

Wed, 08 May 2013 00:00:00 -0400

+ Oracle: REGEXP_LIKE function is supported now.
= Usage of aliases in ORDER BY is corrected.
- MS Access: Support of aliases in ORDER BY clause is turned off.

Active Query Builder ActiveX Edition v.1.20.3

Fri, 26 Apr 2013 00:00:00 -0400

+ Direct connection to ODBC data sources is possible now. You can simply assign
  your ODBC connection string to the ConnectionString property.
= "Check/Uncheck All" items are added to the context menu of derived table's
  field list.
- MS Access: LEFT and RIGHT are accepted as builtin function names now.
- Grouping doesn't set now on assigning sort order for aggregated expressions.
= Additional brackets are added now on loading conditions to a non-empty cell.
- FieldsList.ItemHeight is updated now when TableFont is changed.
= Alias quotation is removed in the Alias column.

Active Query Builder ActiveX Edition v.1.20.2

Fri, 12 Apr 2013 00:00:00 -0400

- Scrolling of partially visible items before check in DataSource check list box
  is handled correctly now.
= Aliases are emitted in the Order By clause when possible.
= French localization is updated.

Active Query Builder ActiveX Edition v.1.20.1

Sun, 07 Apr 2013 00:00:00 -0400

- MS Access: Support of TRIM builtin function is added.
- Incorrect loading of complex conditions fixed
- Interbase: Parsing some builtin functions is fixed.
- Interbase: EXTRACT function is supported.
+ Oracle: Named parameters in function calls are supported now.
- Oracle: resolve ambiguity in parsing qualified column name with method call
- Oracle: Support of CONNECT_BY_ROOT and preserving order of START WITH/CONNECT
  BY is made.
= PostgreSql: Some date/time and system functions like CURRENT_DATE or USER
  could not be quoted. Fixed now.

Active Query Builder ActiveX Edition v.1.20.0

Thu, 28 Feb 2013 00:00:00 -0500

+ Greek translation is added.
+ The new "Add Union Sub-query" button is added to the Union navigation bar.
+ The new button is added to each datasource to collapse/expand it's field list.

Active Query Builder ActiveX Edition v.1.19.11

Fri, 22 Feb 2013 00:00:00 -0500

- Oracle: The DATE built-in function is added.

Active Query Builder ActiveX Edition v.1.19.10

Thu, 21 Feb 2013 00:00:00 -0500

+ Firebird: ROWS clause is supported now.
+ The new IActiveQueryBuilderX.SelectListAlternateRowColor property is made to
  mark even rows of the grid.

Active Query Builder ActiveX Edition v.1.19.9

Mon, 18 Feb 2013 00:00:00 -0500

+ Teradata syntax provider is updated. Query properties form is revised.
- 64-bit OCX is added to the root installation folder.
- Oracle: Support for method call expressions is made.
- Other minor bug fixes are made.

Active Query Builder ActiveX Edition v.1.19.8

Sat, 26 Jan 2013 00:00:00 -0500

+ The x64 version is made.
= The "CTE" prefix is added to the CTE sub-query tabs to distinguish them from
  other sub-queries.
= Unnecesary parens are not written for nested conditions now.

Active Query Builder ActiveX Edition v.1.19.7.1

Wed, 16 Jan 2013 00:00:00 -0500

+ Support of Teradata syntax is made. The xsTeradata (=120) constant should be
  assigned to the SQLSyntax property to use this syntax.
= Conditions like "<= @DT_END AND >= @DT_START" are loaded into one cell now.