Downloads

Active Query Builder VCL Edition History

December 07, 2015

Active Query Builder VCL Edition v.1.26.4

+ Polish translation is added.
+ Oracle: Calculation of SQL expression data types is made.
- Better "IN" lists and date literal recognition in the select list is made.
- MS SQL Server: Date parts are added to the list of valid identifiers.
+ The new SyntaxProvider.IsQueryWithIntoClause method is implemented for
  MS Access, MS SQL Server, PosgreSQL, and MySQL.
- ODBC "fn" call is fixed.
+ Logging of user actions is possible now.

November 16, 2015

Active Query Builder VCL Edition v.1.26.3

+ ODBC literals and function calls syntax is supported now in all SQL
  syntaxes.
- MS SQL Server: YEAR, MONTH and DAY can be used as valid identifiers now, 
  the YEAR builtin function is fixed.
- MS SQL Server: Support for DateAdd function is fixed.
- Oracle: support ListAgg and XmlAgg in analytic expressions
- Oracle: add CYCLE to valid identifiers list
= Advantage DB: Support for Position function is added.
+ PostgreSQL: Support for UESCAPE in unicode string literals is made.
+ The new TacDatasourceObject.ObjectName property is added.
= Condition type column for rows with empty criteria is set now to 
  "for values" in the query columns grid.
- A lot of minor optimizations, improvements and bug fixes are made.

September 18, 2015

Active Query Builder VCL Edition v.1.26.2

+ The new method TacBaseSyntaxProvider.GetKeywords is made to get list of
  reserved keywords.
- MS SQL Server: Support fot IIF function is added.

September 11, 2015

Active Query Builder VCL Edition v.1.26.1

- Netezza: Minor fixes are made.

September 10, 2015

Active Query Builder VCL Edition v.1.26.0

+ Support for RAD Studio 10 Seattle is made.
+ Support for Netezza SQL syntax is added.

July 29, 2015

Active Query Builder VCL Edition v.1.25.5

- Minor fixes in Interbase Express metadata provider are made.

July 24, 2015

Active Query Builder VCL Edition v.1.25.4

- Automatic addition of condition columns in the Query Columns Grid is fixed.

July 10, 2015

Active Query Builder VCL Edition v.1.25.3

- Using RTL flags even for SQL columns in the Query Columns Grid is made.

July 09, 2015

Active Query Builder VCL Edition v.1.25.2

= Teradata: Data type names are displayed correctly now.
= MySQL: Support of "SUBSTRING(a FROM b TO c) is added.
- Advantage: Editing of TOP clause in the Query Properties dialog is fixed.
= Minor improvements for RTL script languages are made.
= Query Transformer: minor bug fixes are made.

June 11, 2015

Active Query Builder VCL Edition v.1.25.1

+ Localization to Farsi language is added.
+ Query Transformer state serialization to XML string is made. 
  Use the TacQueryTransformer.StateXML property to save and load state.
= Grouping checkbox is hidden now for query columns with constant SQL
  expressions.
= Query Column List control now obeys RTL flag for captions, but ignores 
  it for SQL expressions.
= Algorithm trying to preserve conditions order in WHERE and HAVING clauses
  is implemented.
+ AdvantageDB: Support for the CONTAINS full-text search function is made.
+ PostgreSQL: Support for materialized views is made.
= Intofmix: Metadata objects loading is made more reliably now.
- Setting the UnionSubQuery.SQL property to query containing multiple unions
  results in raising EacQueryBuilderError exception now.
- The "Invalid class typecast" error on setting TacSubQuery.SQL property 
  to empty string is fixed.