Downloads

Active Query Builder VCL Edition History

December 05, 2014

Active Query Builder VCL 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 VCL Edition v.1.24.6

+ Support for AdvantageDB SQL syntax is made.
+ The new Subquery Results Preview demo is added to illustrate working 
  with subqueries independently and using Query Transformer to allow
  previewing of sub-query result data.
+ The new AlwaysWrapInSubQuery property is added to TacQueryTransformer
  to instruct the component to wrap original query in sub-query even it 
  is not necessary in order to perform the requested modifications.
= AdvantageDB Metadata Provider: minor bugs are fixed.

October 29, 2014

Active Query Builder VCL Edition v.1.24.5

- General SQL parsing bug is fixed.

October 22, 2014

Active Query Builder VCL Edition v.1.24.4

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

October 21, 2014

Active Query Builder VCL Edition v.1.24.3

+ Fonts scaling support is made.
+ 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).
- MS SQL Server: Pound symbol is removed from the list of valid identifier
  letters.
- Error on canceling execution of non-SELECT statements is fixed.
- Error on deleting datasource in subquery is fixed.

September 17, 2014

Active Query Builder VCL Edition v.1.24.2

= A workaround for incorrect positioning of the Query Columns Grid 
  context menu for Delphi 2009 and earlier is made.

September 12, 2014

Active Query Builder VCL Edition v.1.24.1

- A workaround for DevExpress 2014.1.4 splitter bug is made.

September 11, 2014

Active Query Builder VCL Edition v.1.24.0

+ RAD Studio XE7 support is made.
+ 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 VCL Edition v.1.23.11

- BDE: The bug with connection cloning is fixed.
= TacSubQuery.SQL and TacUnionSubQuery.SQL properties now accept empty strings.
= "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.
= MS SQL Server: A workaround is made for loading metadata through BDE.
= Minor improvements in Localizer are made.

June 27, 2014

Active Query Builder VCL Edition v.1.23.10

= The new internal metadata loading interfaces with directly specified database 
  connection are made.
- QueryTransformer assignment is fixed.
- TacDatasourceControl.Collapsed property is fixed.
- Fields list calculation for recursive CTEs is fixed.