Downloads

Active Query Builder ActiveX Edition History

December 05, 2014

Active Query Builder ActiveX Edition v.1.24.7

+ SQLite: Support CTE at sub-queries level is added.
= Oracle: Oracle8i compatibility fixes are made.
= Comments parsing is fixed.

November 14, 2014

Active Query Builder ActiveX Edition v.1.24.6

+ Support for AdvantageDB SQL syntax is made. 
  Set the SQLSyntax property to xsAdvantage=130 to select this syntax.
- Minor bug fixes are made.

October 29, 2014

Active Query Builder ActiveX Edition v.1.24.5

- General SQL parsing bug is fixed.

October 22, 2014

Active Query Builder ActiveX Edition v.1.24.4

= SQL parser fix is made. (affects all SQL dialects)

October 21, 2014

Active Query Builder ActiveX Edition v.1.24.3

+ SQLite: Backtick quoted identifiers are supported now.
+ SQLite: Support for Common Table Expressions is made. It was added 
  in SQLite v3.8.3 released on 2014-02-03.
+ The new property SelectListOptions.CreateColumnAliasesForUnnamedColumns
  is added to instruct the component to add aliases for unnamed fields 
  (expressions, aggregates) automatically. It is turned on by default.
= MS SQL Server, DB2: QueryTransformer now uses ROW_NUMBER ranking function
  to implement Skip and Take methods for these servers.
- Add Linked Objects menu now creates links for all fields for multi-column
  foreign keys (not only for the first field).
- Error on deleting datasource in subquery is fixed.
- MS SQL Server: Pound symbol is removed from the list of valid identifier
  letters.

September 11, 2014

Active Query Builder ActiveX Edition v.1.24.0

+ The new SelectListOptions.ResolveColumnNamingConflictsAutomatically
  property is added to instruct the component to generate unique aliases 
  for explicitly specified query columns to avoid duplicated column names.
+ PostgreSQL: RECURSIVE keyword in WITH clause support is added.
+ Parametrized queries are used now to fetch fields list for MS SQL Server
  and Oracle to reduce the load on the server when retrieving metadata.
+ Oracle: SearchClause and CycleClause in WithClauseItems is supported.
= Case-insensetive comparison is used now when creating unique aliases.
- MySQL: Quoted characters in string literals are supported now.
- Firebird: WEEK date part support is added.

August 05, 2014

Active Query Builder ActiveX Edition v.1.23.11

= "No linked objects" menu item is shown if linked ojbects are not found.
+ MS SQL Server: Support for new analytic functions SQL Server 2012 is made.
+ Datasource is focused on mouse hover to display the linked objects button.

June 27, 2014

Active Query Builder ActiveX Edition v.1.23.10

- TacDatasourceControl.Collapsed property is fixed.
- Fields list calculation for recursive CTEs is fixed.

June 10, 2014

Active Query Builder ActiveX Edition v.1.23.8

= QueryTransformer does not wrap query if limits are empty.
= QueryTransformer obeys the QueryBuilder.SleepMode flag now.

June 09, 2014

Active Query Builder ActiveX Edition v.1.23.7

= Universal syntax: Query properties form to add DISTINCT clause is added, 
  list of reserved words is extended.
= MS Access syntax: It is possible to parenthesize complex join expressions 
  as it's necessary when working with MS Excel. 
= OLE DB connection: Forced to sort list of fields by ordinal position.