Active Query Builder VCL Edition History

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
- 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
- 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
= 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

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.

Product Summary

 Active Query Builder WinForms .NET Edition:

 Active Query Builder WPF .NET Edition:

 Active Query Builder ASP.NET Edition:

 Active Query Builder Java Edition:

 Active Query Builder ActiveX Edition:

 Active Query Builder VCL Edition:




We have been using Active Query Builder for over a year and must say that both the product and support have been outstanding!

We chose Active Query Builder due to its flexibility and features, but have been truly pleased by its power and hidden capabilities. ...

In summary Active Query Builder provides excellent components, great support and a very flexible feature set. It has allowed us to provide features to our end users that I did not think would be possible in the first release of our new tools and in a timeframe that was much shorter than planned. I would recommend that anyone dealing with databases in the .Net world should be aware of this component and its capabilities!

Social networks