Active Query Builder VCL Edition History

June 27, 2014

Active Query Builder VCL Edition v.1.23.10

= The new internal metadata loading interfaces with directly specified database 
  connection are made.
- QueryTransformer assignment is fixed.
- TacDatasourceControl.Collapsed property is fixed.
- Fields list calculation for recursive CTEs is fixed.

June 12, 2014

Active Query Builder VCL Edition v.1.23.9

- More fixes for Allround Automations DOA metadata provider are made.
= Package descriptions are fixed.
= The "Preload Metadata Container" design-time command is re-enabled.

June 10, 2014

Active Query Builder VCL Edition v.1.23.8

- AdvantageDB, NexusDB, AllroundAutomations DOA: AV in GetConnection method 
  is fixed.
= QueryTransformer does not wrap query if limits are empty.
= QueryTransformer obeys the QueryBuilder.SleepMode flag now.

June 09, 2014

Active Query Builder VCL Edition v.1.23.7

- Allround Automations DOA connectivity package is fixed.
- AV on asyncronous metadata loading when main component is hidden is fixed.
= Universal syntax: Query properties form to add DISTINCT clause is added, 
  list of reserved words is extended.
= MS Access syntax: It is possible to parenthesize complex join expressions 
  as it's necessary when working with MS Excel. 
= OLE DB connection: Forced to sort list of fields by ordinal position.
= QueryTransformer object can be assigned now.

May 27, 2014

Active Query Builder VCL Edition v.1.23.6

= Full-featured demo project: New generic dataset interface is used.
- DevArt SQL Server DAC and NexusDB connectivity fixes are made.
= Query Transformer: SortedColumn.SortType property setter is added to allow
  changing of sort order.
= Better MySQL queries cancelation for asyncronous SQL execution is made. 
- A workaround for ADO parameter types bug is made.
- MS SQL Server: A workaround for loading metadata via ODBC driver is made.

May 13, 2014

Active Query Builder VCL Edition v.1.23.4

- Support for NexusDB 3.12 is added.
= Small improvements in asyncronous SQL execution are made. 

May 07, 2014

Active Query Builder VCL Edition v.1.23.3

- Installation for Delphi XE6 is fixed.
= MS Access: Backtick-quoted identifiers are accepted now. They will be converted
  to square brackets during the query generation.

May 06, 2014

Active Query Builder VCL Edition v.1.23.2

- Prevent races on RefreshMetadataAsync and RefreshMetadata calls.
- Installer: RAD Studio XE6 detection is fixed
+ Syntax Providers: The new set of functions to pack/unpack date, time and
  timestamp literals.
= AnyDAC2: Default command timeout is set to 0 (unlimited) instead of 30
- Minor fixes in the Query Transformer are made.

April 29, 2014

Active Query Builder VCL Edition v.1.23.1

- MS SQL Server: Parsing of aggregated functions is fixed.
- DB2: Parsing of Hex, Graphics and Unicode string literals is fixed.
- MS Access: Built-in functions list is fixed.

April 23, 2014

Active Query Builder VCL Edition v.1.23.0

+ RAD Studio XE6 support is added.
+ Connection cloning and asyncronous SQL execution is possible now.
+ Asyncronous metadata loading support is made.
+ MS SQL Server: MS SQL Server 2014 is supported.

- MS SQL Server: method call chain parsing is fixed.
= MS SQL Server: keywords list is updated.
+ PostgreSQL: WITH clause support is made.
= PostgreSQL: The "LIMIT 0" constraint is used for queries to fetch object
  columns (formerly used "LIMIT 1").
+ Oracle: Parsing DATE, TIME and TIMESTAMP literals is fixed.
+ Oracle: Interval expressions are supported now.
= DB2, MySQL, PostgreSQL, ANSI SQL: DATE, TIME and TIMESTAMP literals are
  supported now.
= DB2: Short object names are used in case of SYSTEM naming convention.
- MySQL: DATE and TIME types parsing ambuiguities fixed.

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