Downloads

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