Downloads

Active Query Builder VCL Edition History

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.

June 30, 2021

Active Query Builder VCL Edition v.1.30.11

+ The initial support for Denodo Virtual Dataport is made.
+ Criteria Builder: Filtration and search with highlighting in the
  suggestion grid is made.
= Criteria Builder: IS (NOT) NULL, and NOT EQUALS operators are allowed for
  boolean field conditions.
= Query Transformer: The fields case is preserved now for a wrapped query.
- Query Transformer: The bug with ORDER BY generation for a wrapped query is
  fixed.
- Automatic generation of short aliases is fixed when the object is added to
  the query from the linked objects menu.
- Metadata object names generation and comparison are fixed when the server
  generally supports schemas, but the server returns an empty schema.
= The generation of SQL query text is made thread-safe.
= Nodes aren't loaded to the metadata tree now if it is hidden.
- The bug with not updating the SQL text on editing a subquery in the link
  expression is fixed.
= MS SQL Server: The support for TRY_CAST and TRY_CONVERT built-in functions
  is added.
= Teradata: A fallback to non-X system views is made if X-views are not
  available.
- Teradata: The server autodetection is fixed.
- Pervasive: Parsing of the IF, DateAdd, DateDiff, and DatePart built-in
  functions and the DOUBLE built-in type are fixed.
- DB2: Parsing of the EXCEPTION JOIN and backslash as a division in
  expressions are fixed.
- SAP Hana: The IsSupportDatabase flag is turned off.

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.