Downloads

Active Query Builder VCL Edition History

March 10, 2021

Active Query Builder VCL Edition v.1.30.10

= SQL Text Editor: Minor autocompletion fixes have been made.
= The length of automatically generated aliases for single-word names is 
  set to 3 characters; the maximum length is limited to 5.
- MySQL: "PRECEDING" and "POSITION" clauses are fixed.
= FireDac Metadata Provider: The internal FireDac macro-expansion has been 
  turned off as it breaks some servers.

February 02, 2021

Active Query Builder VCL Edition v.1.30.8

+ The component generates short object aliases for objects added to the
  query if the QueryBuilder.GenerateShortObjectAliases is set to True.
= SAP HANA: Support for the CONVERT_UNIT built-in function has been added.
= MySQL: Support for UTC_DATE, UTC_TIME, UTC_TIMESTAMP functions has been
  made.
= MySQL: Parsing of the RECURSIVE keyword in the WITH clause has been fixed.
= MS Access: Parsing of optional identifier before subquery in the FROM
  clause has been fixed.
= NexusDB: Remote NexusDb server dependencies have been removed from the
  metadata provider.
- Query Transformer: Multi-level filters have been fixed.
- Criteria Builder: The bug on pressing the Esc key in the popup list has
  been fixed.
- The Access violation exception on loading complex query with ORDER BY
  column indices has been eliminated.
- PostgreSQL: The PRECISION token has been added to the list of valid
  identifiers.

December 21, 2020

Active Query Builder VCL Edition v.1.30.7

= PostgreSQL: Support for the parenthesized subqueries has been added.
= Informix: Support for the LIMIT clause is added.
- Generic SQL syntax: Support for ABS built-in function is added.
- MySQL: The bug with the special syntax of POSITION has been fixed.

August 08, 2020

Active Query Builder VCL Edition v.1.30.6

+ Support for Intuit QuickBooks SQL syntax is added.
= The Query Structure Demo has been improved by processing IN, LIKE and BETWEEN
  nodes in the DumpExpression method.
- MySQL: The bug with adding "=TRUE" or "=FALSE" for logical expressions has 
  been fixed.
- MySQL: The Tilda character "~" is removed from the set of valid characters
  for identifiers.
- SAP Hana: TOP, DISTINCT, and PLACEHOLDER clauses are generated at the right
  place and order now.

June 17, 2020

Active Query Builder VCL Edition v.1.30.5

+ Expression Editor: Hints in the list of functions are displayed much longer.
- The exception in RAD Studio 10.4 on form loading is eliminated.
- Installer: SQL Direct DAC detection has been fixed.
- Installer: PackagesDir calculation for C++Builder 6 has been fixed.

June 11, 2020

Active Query Builder VCL Edition v.1.30.4

+ Support for RAD Studio 10.4 Sydney has been added.
+ Users now can create links from UI separately indicating the beginning and 
  end field via the datasource field context menu.
= PostgreSQL: Backslash quotation for generic string literals has been removed.
- TacCriteriaBuilder: The bug with defining general condition has been fixed.

May 22, 2020

Active Query Builder VCL Edition v.1.30.3

= Design Pane: Datasource captions are made more contrast.
= Usability of building queries with grouping has been improved by a series
  of small fixes.
+ The new property QueryBuilder.SwapSidePanels has been added to swap the 
  Database Schema Tree and the Query Structure Tree.
- SQL Text Editor: Minor fixes and improvements for the suggestions list
  have been made.
= SQL Text Editor: The new property SqlTextEditorOptions.SyncSuggestionLoading
  has been made for DACs having problems with running queries in threads.
+ Oracle: params and fields for stored procs, table functions loading fix
= Oracle: Synonyms are loaded faster now.
- Oracle: The bug in the QueryTransformer that led to incorrect query 
  generation has been fixed.
- SQL Server: Loading field comments for objects from non-default schemas 
  and databases has been fixed.
+ PostgreSQL: Support for the WINDOW, FILTER clauses has been added.
+ SQLite: Support for the WINDOW and FILTER clauses and analytic expressions
  has been added.
= SQLite, Teradata: Support for the REPLACE function has been fixed.
= SAP Hana: Support for TOP and PLACEHOLDER clauses, NVARCHAR builtin type,
  CURRENT_UTC* constants have been added.
+ SAP Hana: Metadata filters are applied now to metadata fetching queries.
- SAP Hana: Working with table functions has been fixed.
= Nexus DB: Support for the TOP clause has been added.
= Nexus DB: QueryTransformer now supports Skip and Take methods.

December 25, 2019

Active Query Builder VCL Edition v.1.30.1

+ Now you can assign an SQL script with DECLARE and SET statements preceding 
  the SELECT query to the TacPlainTextSQLBuilder.SQL property.
  The component will bypass statements preceding the first SELECT statement,
  lets you edit the SELECT statement and get back the script with the 
  preceding statement and the modified SELECT statement.
+ SAP Hana & ANSI Standard SQL Syntax: Support for the standard 
  TRIM(LEADING/TRAILING ...) builtin function is added.
+ TacSQLScript: The new TacSqlStatement.IsSelect property is added.
= TacSQLScript: New helpers to load and save the script to/from file and
  stream are added.
= TacSQLScript: The SqlStatement property is renamed to Statements.
- Oracle: Paging with ROWNUM has been fixed.
- MySQL: Parsing of the MATCH full-text search expressions has been fixed.

December 13, 2019

Active Query Builder VCL Edition v.1.30.0

Standard edition:
+ The new component TacSQLScript splits the query by statements, allows to 
  look through them and edit separate statements in it.
+ The new TacQueryParametersTransformer component is added to: 
  1. cut off conditions with undefined parameter values, 
  2. convert parameter notation to the colon-prefixed notation.
= Query Columns List: Handling of incomplete strings in expression cells 
  has been improved.
- PostgreSQL: Support for WITH clause in subqueries has been added.

Professional version:
+ The new TacQueryParametersTransformer is also capable to deal with macros.
  Using it you can replace a single parameter with a list of values, SQL 
  expression or sub-query. 
+ SQL Text Editor: The suggestion list now works smoothly, filters items to
  suggest smarter and loads the needed metadata in a thread. 
+ SQL Text Editor: New properties have been added to tune colors and 
  suggestion behavior.
+ SQL Text Editor: Highlights the current SQL statement and provides methods
  to get and set the current SQL statement.
= SQL Text Editor: Other fixes and usability improvements have been made.

October 17, 2019

Active Query Builder VCL Edition v.1.29.11

+ SQL Text Editor: The content of suggestion list is now loaded and 
  calculated in a background thread.
- Minor bugs in the Query Structure Tree have been fixed.
+ Oracle: OFFSET/FETCH support for Oracle 12+
+ PostgreSQL: add DISTINCT ON support
= New properties have been added to ANSI standard and Universal syntax
  providers: IsSupportDatabases and IsSupportSchemas.
= Informix: Support for new built-in functions (LEFT, RIGHT) has been added.
+ Informix: Support for derived tables for IDS11+ has been made.
= Informix: Objects from all schemas can be used without schema prefix.
- PostgreSQL: Comparison operators precedence has been corrected.
= PostgreSQL: Handling of "partial" expressions like "=1" is improved.
- PostgreSQL: Filtration of camel-cased names using QueryTransformer has 
  been fixed.
- Pervasive: The bug with a dot before the table name has been fixed.