Downloads

Active Query Builder VCL Edition History

April 12, 2022

Active Query Builder VCL Edition v.1.31.9

= Criteria Builder: Entering values in the list editor is made easier:
  Enter now moves focus to the next item, Alt+Home/End shortcuts move focus to
  the first/last item in the list.
= Criteria Builder: Automatic transition between date parts in DateTime picker
  when typing is made.
= Criteria Builder: Icons are scaled properly in HiDPI resolutions now.
- Criteria Builder: Entering minutes same as months is fixed in the DateTime
  picker.
= Design Pane: Join type markers in MSSQL-style mode are scaled properly in
  HiDPI resolutions now.
- Query Column List: Row selection and re-ordering by mouse is fixed.
- Query Column List: "=TRUE" is added automatically to the Criteria cell on
  entering logical expressions like "EXISTS" sub-queries.
= MS SQL Server: Support for "FOR JSON" clause is added.
= MS SQL Server: Support of JOIN without type is added. 
- Oracle: Parsing of default value clause for conversion functions is fixed.
- SAP Hana: Parsing of YEAR/HOUR/MINUTE/... builtin functions is fixed.
- PostgreSQL: The DEFAULT token is added to the list of keywords.
- InterBase: The bug with applying limits in the QueryTransformer is fixed.
- SQLite: Extracting DateTime values from the parsed expression is fixed.

February 17, 2022

Active Query Builder VCL Edition v.1.31.8

+ SAP Hana: Support for analytic expressions is added.
- MS SQL Server: The TIME built-in type parsing is fixed.
- Pervasive DB: The ambiguity in the IF built-in function parsing is 
  eliminated, so parsing is speeded up.
- Pervasive DB: Parsing of the DatePart keywords as identifiers are fixed.
- The bug with OLE drag'n'drop registration for the select list grid control
  is fixed.

January 19, 2022

Active Query Builder VCL Edition v.1.31.7

+ SQL Server: Support for the "AT TIME ZONE" operator is added.
= Denodo Virtualization Server: The list of reserved words is updated.
= Informix: The bug with the impossibility to use some keywords as identifiers
  is fixed.
- TacQueryParametersTransformer: SQL generation is fixed in some cases.
- The exception on loading queries with index-referenced columns in ORDER BY is
  eliminated.
- The bug on selecting the "Check all" action in the datasource field list for
  queries with grouping is fixed.
- The exception on re-calculation of datasource control captions in some cases
  is eliminated.

November 11, 2021

Active Query Builder VCL Edition v.1.31.6

= Design Pane: Datasources don't grab the focus on mouse hover now.
= SQL Text Editor: Gutter width is updated properly on Text Editor font 
  changing. 
= MySQL: Fields are fetched sorted by ORDINAL_POSITION now.
= SQLite: A load of foreign keys is improved.
- Metadata Filter: The exclusion filter condition generation for filter items
  with both non-empty SchemaMask and ObjectMask is fixed.

November 01, 2021

Active Query Builder VCL Edition v.1.31.5

- The bug with loading images from named resources when ActiveQueryBuilder
  resources are compiled into a separate DLL (or BPL package) is fixed.

October 29, 2021

Active Query Builder VCL Edition v.1.31.4

= Column aliases that are valid identifiers aren't quoted now.  
+ The new SelectListOptions AlwaysQuoteColumnAliases property is added. 
  Default is false.
= QueryTransformer: On the select list expansion, column aliases are assigned
  for all fields, not only for renamed ones.
= CriteriaBuilder: The bug with displaying dates in lookup and list popup 
  editors is fixed.
- DevExpress UI: The access violation error on deleting a datasource from 
  the Design Pane is eliminated.
+ SQLite: Date, Time and DateTime conversion built-in functions are added.
= Firebird: CTE in subqueries are supported now. 
- Oracle: The bug with applying limits for server versions without 
  OFFSET/FETCH support is fixed.

October 14, 2021

Active Query Builder VCL Edition v.1.31.3

+ SimpleFilter now supports object masks (%, _).
- The Access Violation error on dragging objects from the Metadata Tree in 
  specific circumstances is eliminated.

October 08, 2021

Active Query Builder VCL Edition v.1.31.2

- The Access Violation in TacSqlTextEditor on assigning a semi-initialized
  TacQueryBuilder with AutoSyntaxProvider has been eliminated.

October 05, 2021

Active Query Builder VCL Edition v.1.31.1

+ It is now possible to Show/Hide Unused fields for all objects on the Design
  Pane via the context menu.
= Minor interface improvements for datasource fields filtration are made.
= Better placement of new datasources on the query diagram is made.
+ SQL Text Editor: The Ctrl+Delete shortcut is added to remove the token part 
  at the left of the caret. (The Ctrl+Backspace removes the right part.)
= SQL Text Editor: The Shift+tab behavior shortcut has been changed. If there's
  no selection, it unindents the string if it's on the right of the caret,
  otherwise moves the caret left.
- Informix: The bug with missing built-in functions has been fixed.
- Oracle: The bug with queries containing DbLink objects has been fixed.
- A memory leak is fixed.

September 30, 2021

Active Query Builder VCL Edition v.1.31.0

+ Support for RAD Studio 11 Alexandria has been made.
+ Now it's possible to filter fields in datasources on the Design Pane.
+ Informix: Support for databases, double-quoted strings, curly-braced 
  comments are added; the keywords list is updated.
= MySQL: ANSI_QUOTES server option autodetection is made.
= TacSqlBuilder: The new property BuiltinFormat is added to determine the case 
  of built-in functions and variables.
= FireDACMetadataProvider: The new property LoadPkFieldsFromDriver is added to
  determine whether it's needed to retrieve the information about primary keys
  using FireDAC Meta helpers or not.
= TacSqlStatement: the Start property is renamed to StartPos, the new EndPos 
  property is added.
- The crash on adding CTE in some cases has been eliminated.
- Simple Metatada Filter: The bug with the filter for case-sensitive columns is
  fixed.
- Minor fixes in the TacQueryTransformer are made.