Downloads

Active Query Builder VCL Edition History

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.

May 19, 2015

Active Query Builder VCL Edition v.1.25.0

+ Support for RAD Studio XE8 is added.
+ Compatibility with VCL Styles is improved.
+ Support of RTL languages is improved.
+ Ability to select muptiple rows in the Query Columns Grid eases 
  re-ordering of query columns.
= The Aggregate column of the Query Columns Grid is moved closer to the 
  Grouping column.
= Now when query grouping is cancelled by unchecking the main Grouping 
  option, the ConditionType ("Criteria For" column) is set to ctWhere 
  ("For values") only for non-aggregated columns.
+ IacTask: Support for cancelation of the task in another thread is made.
+ IacAsyncSql: The OnCustomizeDataset event is added to change parameters of 
  dataset after it's creation.
+ IacAsyncSql: Ability to use the given DB connection is added.
= The QueryBuilder.OnSelectListColumnWidthsChanged event is now fired only
  for changes made by the user.
- QueryTransformer: Wrapping of queries with several unnamed columns is
  fixed.
= ANSI SQL/2003: Using the TABLE wrapper for stored procedures in FROM is 
  possible now.
+ AdvantageDB: Support for IIF builtin function is made.
- AdvantageDB: Parsing of the LEFT and RIGHT builtin functions is fixed.
- MySQL: Support for CHAR builtin function is made.
- DB2: Duplication of the TABLE wrapper for stored procedures is fixed.
= Informix: The system "INFORMIX" schema now treated as non-system if no
  other schemas are found.

March 24, 2015

Active Query Builder VCL Edition v.1.24.12

- PostgreSQL: LIKE (ANY|SOME|ALL) is supported now.
- Query Transformer: Construction of NOT BETWEEN condition is fixed.
= Column aliases entered in the Query column list are always quoted now 
  to preserve the case. 
+ The new QueryBuilder.OnSelectListColumnWidthsChanged is made. 
  Helpers to get/set columns widths are added.
+ Query columns list height and columns width are preserved now on query
  reloading and manual SQL text changes.
= The QueryBuilder.ColumnsPaneHeight setter is improved.
- The QueryBuilder.Clear method is fixed.
= TacBaseSyntax: Better date/time parsing helpers are made.

March 10, 2015

Active Query Builder VCL Edition v.1.24.11

= Focus is not moved on mouse hover over datasources on the Design pane
  if the component is not focused.
= The TacSubQuery.SetSql method now accepts CTE for the main query.
= The TacUnionSubQuery.SQL property now emits empty string for empty queries.
= Support for database connection activity logging is made.
- Incorrect loading of ORDER BY is fixed.

February 06, 2015

Active Query Builder VCL Edition v.1.24.10

+ Support for NexusDB v.4 is made.
= The OnActiveSubQueryChanging and OnActiveUnionSubQueryChanging
  events signatures are changed. Now you can deny sub-query changing.
= Minor parsing speed improvements are made.

January 21, 2015

Active Query Builder VCL Edition v.1.24.9

- Component usage under the Win64 platform is fixed. 
= Scanner performance optimizations are made.