Active Query Builder VCL Edition History

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. 

September 23, 2018

Active Query Builder VCL Edition v.1.28.10

+ SQL Text Editor: Autocompletion improvements and fixes have been made.
= German localization has been updated 
= DevExpress: MetadataTreeNodeGetHintText event is fired now.
- Minor bugs have been fixed.

August 14, 2018

Active Query Builder VCL Edition v.1.28.9

= DevExpress UI: Better application of skin colors has been made.
- Minor improvements in the Load Metadata demo project have been made.
- A memory leak for non-unicode Delphi versions has been eliminated.

July 13, 2018

Active Query Builder VCL Edition v.1.28.8

+ Initial support of SAP Hana SQL syntax has been added.
= Oracle: Support for the new Oracle 12c LISTAGG syntax has been added.
= Pervasive: List of keywords and functions has been filled.
= Pervasive: Support of IF function, LIMIT/OFFSET clause has been made.
- Pervasive: Parsing of date/time builtin functions has been fixed.
- Teradata: The bug with the autodetection of new versions has been fixed.
- SQLite: Parsing of queries with RIGHT and FULL joins throws the parsing
  exception now.
- IBM DB2: NULL is parsed as a constant, not as an identifier.
= The new limitation of the trial edition: generation of random aliases for
  the query output columns.
+ The new method TacSubQuery.GetSqlForDataPreview() returns correct SQL query
  to preview the sub-query result data.
= The LinkOptions.CreateLinksByIdenticalFieldNames behaviour has been changed.
  Links are created only if one of the fields is a part of the primary key.
= FireDAC: Loading of Primary Key fields has been improved.
= Complex SQL expressions aren't loaded as joins anymore.
- Changing of the link type if RIGHT JOIN is not supported is not allowed now.
- The bug with the height calculation of the UNION navigation bar when the
  query has unions in brackets has been fixed.
- Memory leaks have been eliminated.

March 15, 2018

Active Query Builder VCL Edition v.1.28.7

- Access violation on creating TacQueryBuilder component in RAD Studio 10.2.3
  has been fixed.
= SQLite: The list of reserved words has been filled.

February 28, 2018

Active Query Builder VCL Edition v.1.28.6

= Parsing of incorrect/incomplete "IN" expressions in condition cells of 
  the Query Columns List has been improved.
- DevExpress: Access violation in the IDE form designer if
  TdxSkinController exists on a form has been eliminated.

February 22, 2018

Active Query Builder VCL Edition v.1.28.5

+ Initial support of Pervasive SQL syntax has been added.
- DevExpress UI: Theme colors are applied automatically now.
- Links cardinality calculation has been fixed.
- MS SQL Server: Multi-column foreign keys loading for SQL Server 2005 and 
  higher has been fixed.
- MySQL: Support of STDDEV function has been fixed.

January 27, 2018

Active Query Builder VCL Edition v.1.28.4

= Index numbers in ORDER BY are converted to corresponding expressions now.
= PostgreSQL parser has been optimized.
  an arbitrary order has been fixed.
- Oracle, MySQL, MS SQL Server: Several SQL parsing fixes have been made.
= FireDAC: Fetching of databases and schemas is supported now.
+ FireDAC The new TacFireDACMetadataProvider.LoadStoredProcedures property
  (default false) has been added. It instructs to load stored procedures
  from the driver. Turn it on only for the database servers which support
  using them in the FROM clause of the SELECT statement.

December 19, 2017

Active Query Builder VCL Edition v.1.28.3

= Compatibility with the latest DevExpress 17.2 version.
= MS SQL Server: The DB_NAME function is used now to get the current db name
  on MS SQL Server 2008 and higher.

December 07, 2017

Active Query Builder VCL Edition v.1.28.2

+ Sybase: Support of window functions has been added.
= Teradata: Fetching fields from server system catalog has been speeded up.
= Query Columns Grid: parsing of user input of criteria has been improved.
- SQL Anywhere: Detection of new versions has been fixed.
- Oracle: Unsupported comparison operators !> and !< have been removed.
- SQL parsing has been speeded up.

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