Active Query Builder VCL Edition History

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

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
- 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
+ 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.

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