Downloads

Active Query Builder VCL Edition History

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.

May 08, 2019

Active Query Builder VCL Edition v.1.29.4

+ Dutch localization has been added.
+ The Query Structure Tree is improved. It is more sensibly organized and 
  allows performing various actions with nodes using context menus. 
+ New methods to get the list of linked servers and databases from them are
  added: GetServersList, GetDatabasesList(serverName)
= MS SQL Server: Objects from linked servers without database or schema
  support are retrieved fine now.
= The Create Query Demo has been rewritten. It includes more code samples of
  programmatic SQL query creation.
= MySQL: The default server version is set to 8.0.
= Pervasive: Parsing of some built-in functions has been fixed.
= Minor SQL formatting fixes and improvements have been made.
= PostgreSQL: "table.*" is accepted now as an ordinary row expression term.
= NexusDB: The list of reserved words has been updated.
= SAP Hana: Support for missing functions has been added: LEFT, RIGHT and
  (REPLACE/SUBSTR/OCCURRENCES)_REGEXPR.
- Scaling issues have been fixed.
- The bug with not switching to the new subquery on creating a Derived Table
  has been fixed.
- CrMyDACMetadataProvider: A workaround for the MyQuery.PSSetParams issue 
  has been made.
- AdvantageMetadataProvider: Client package name for newer Delphi versions
  has been updated.

January 21, 2019

Active Query Builder VCL Edition v.1.29.3

+ NexusDB syntax provider has been added.
- Turning off grouping in the query via the global Grouping checkbox in the
  header of Query Columns List may lead to inconsistent queries. Fixed now.
= DBISAM: Client package name is updated for compatibility with the latest
  DBISAM v.4.47.
- PostgreSQL: Parsing ambiguities for INTERVAL and AT TIME ZONE clauses have
  been fixed.

December 11, 2018

Active Query Builder VCL Edition v.1.29.0

+ Support for RAD Studio 10.3 Rio has been added.
+ Support for DevExpress controls v.18.2 has been added.
+ Initial support of SAP Hana SQL syntax has been added.
+ Initial support of Pervasive SQL syntax has been added.
+ MySQL: Support for Common Table Expressions for MySql v8+ has been added.
+ SQL Text Editor: Code auto-completion improvements and fixes have been
  made.
+ Now it's possible to add and remove rows in the Query Columns List using
  the Alt+Insert and Alt+Delete keyboard shortcuts, move them up and down
  using the Alt+[Arrow Up/Down] keys.
= Parsing of incorrect/incomplete "IN" expressions in condition cells of 
  the Query Columns List has been improved.
= The behavior of LinkOptions.CreateLinksByIdenticalFieldNames property
  has been changed. Links are created only if one of the fields is a part 
  of the primary key.
= DevExpress UI: Better application of skin colors has been made.
+ The new  properties have been added to the QueryBuilder object to hide the
  controls for managing subqueries: SubQueryTabsVisible, UnionNavBarVisible.

November 19, 2018

Active Query Builder VCL Edition v.1.28.11

+ NexusDB syntax provider has been added. 
+ MySQL: Support for Common Table Expressions for MySql v8+ has been added.
+ The new  properties have been added to the QueryBuilder object to hide the
  controls for managing subqueries: SubQueryTabsVisible, UnionNavBarVisible.
= Oracle: Support for ranking functions has been updated.
- PostgreSQL: Parsing of the "AT TIME ZONE" clause and "EXTRACT(epoch FROM 
  ...)" function has been fixed.
- MS Access: Parsing of the TRUE and FALSE constants has been fixed.
- The Union Navigation Bar scaling issues have been eliminated.