Downloads

Active Query Builder VCL Edition History

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.

July 24, 2019

Active Query Builder VCL Edition v.1.29.10

- The bug with an empty schema for generic ANSI SQL syntax providers has been
  fixed.

July 12, 2019

Active Query Builder VCL Edition v.1.29.9

- SQL Text Editor: The unhandled exception on user typing in specific 
  circumstances has been fixed.

July 09, 2019

Active Query Builder VCL Edition v.1.29.8

+ SQL Text Editor: The new TextEditorOptions.ReadOnly property has been added.
= SQL Text Editor: The suggestion window behavior has been improved.
= SQL Text Editor: MySQL analytic functions are added to the suggestion list.
= SQL Text Editor: The events for drag'n'drop have been added; support for 
  OLE text drag'n'drop has been made.
= SQL Text Editor: Mouse is captured on selection now.
+ SQL Text Editor: New events are added to customize lists of keywords and
  builtin functions: OnCustomizeKeywords and OnCustomizeFunctions.
- SQL Text Editor: Typing of colon-prefixed parameters has been fixed.
- SQL Text Editor: Slowness in displaying the suggestion list in the case
  of a large database schema has been eliminated.
= TreeOptions: CTEsNodeText and SubQueriesNodeText props are writable now.
- DevExpress: UnionNavBar auto sizing has been fixed.
- Dot-prefixing objects with an empty schema for servers without database
  namespace support has been fixed.
- QueryTransformer: The assignment of random column aliases for transformed
  queries in the Trial version has been fixed.

July 06, 2019

Active Query Builder VCL Edition v.1.29.7

+ Query Structure Tree: sub-queries from WHERE and SQL expressions from other
  parts of the query are shown in the tree now.
+ New methods TacQueryBuilder.GetSqlAst/SetSqlAst are added to get/set the
  parsed AST query tree.
= Query Transformer: SQL-text based transformations are made with the query 
  AST tree now.
= AST tree operations have been speeded up.
= Log: the version number is now displayed in the "log opened" message.
= Universal Syntax Provider: add syntax properties autodetection is logged now.
- DevExpress: The width of buttons in the UnionNavBar is fixed.

July 01, 2019

Active Query Builder VCL Edition v.1.29.6

= New server versions are listed now for MySQL, MS SQL, Oracle syntaxes.
= Link Properties Form: The single-line expression editor has been replaced
  with a memo field.
- Visibility of the UnionNavBar is restored correctly now after updating 
  the UnionTabSheet params.
- SAP SQL Anywhere: Loading of objects for a non-privileged user has been
  fixed; modern views are used now for v.17 and higher.
- Universal Syntax Provider: The detection of database and schema namespaces
  usage is performed now. It now works fine with the Absolute DB.
- SQLite: Union operators list has been fixed.

May 14, 2019

Active Query Builder VCL Edition v.1.29.5

= SQL Text Editor: Keywords for NexusDB syntax have been updated.