Downloads

Active Query Builder VCL Edition History

August 29, 2013

Active Query Builder VCL Edition v.1.21.6

= Alternate Names now obey server identifier case sensitivity rules.
- The bug with incorrect bracketing of inner OR conditions is fixed.
= MS Access: Builtin functions siffixed with the dollar sign are supported now.
- Oracle: Usage of the "TIMESTAMP" keyword as column name is possible now.
= MS SQL Server: Table hints are updated according to the SQL Server 2012 
  specification.

June 27, 2013

Active Query Builder VCL Edition v.1.21.4

- Recently introduced bug that led to the emptiness of field lists is fixed.
- Minor bug fixes and improvements for DevExpress UI are made.

June 20, 2013

Active Query Builder VCL Edition v.1.21.3

- DevExpress PageControl skin painter package is added to the list of referenced
  packages of acQueryBuilder package.

June 18, 2013

Active Query Builder VCL Edition v.1.21.1

+ The new properties are added to fine tune the component's layout:
  TacQueryBuilder.OptionsView.TreeMargins property allows to remove margins
  around the TreeViews, TacQueryBuilder.OptionsView.SplitterResizeUpdate turns
  off immediate resizing when splitter moves.
+ The new TacQueryBuilder.OnLayoutChanged event is made to control changes in
  layout of the query. It is fired when datasource is moved on the Design Pane.
= PostgreSQL: LEFT and RIGHT builtin functions are supported now.
+ The new TacBaseSyntaxProvider.QueryToLoadFieldsTemplate property is made.
+ DevExpress: IncSearch in treeviews is turned on, horizontal splitter is added
  to the Query Columns Grid.

May 30, 2013

Active Query Builder VCL Edition v.1.21.0

+ The new TacQueryTransformer component is added. It is intended to easily
  modify SQL query sorting, filtration and aggregation programmatically. 
+ RAD Studio XE4 support is added.
= The new TacBaseSyntaxProvider.AppendLimitsForFieldsQuery property is added
  to enable/disable the "0<>0" condition in the field list retrieval queries. 
+ The new properties are added to the TacExpressionBuilderParams class that is 
  passed to the OnCustomExpressionEditor event handler:
  ExpressionKind (ekExpression, ekWhere or ekHaving), RelatedExpression,
  RelatedField, RelatedObject.
= Internal change: Binding of column names is not performed now if fieldless
  datasources are in the scope.
= MySQL: The BINARY prefix operator is supported now.

May 08, 2013

Active Query Builder VCL Edition v.1.20.4

+ Oracle: REGEXP_LIKE function is supported now.
= Usage of aliases in ORDER BY is corrected.
= Minor fixes and improvements for DevExpress controls UI are made.
- MS Access: Support of aliases in ORDER BY clause is turned off.

April 26, 2013

Active Query Builder VCL Edition v.1.20.3

= TacQueryTransformations: Addition of OR conditions is possible now.
= "Check/Uncheck All" items are added to the context menu of derived table's
  field list.
- MS Access: LEFT and RIGHT are accepted as builtin function names now.
- DevExpress drawing artifacts are fixed.
- Grouping doesn't set now on assigning sort order for aggregated expressions.
= Additional brackets are added now on loading conditions to a non-empty cell.
= Component version is shown in the TacQueryBuilder context menu in design time.
- FieldsList.ItemHeight is updated now when TableFont is changed.
= Alias quotation is removed in the Alias column.

April 12, 2013

Active Query Builder VCL Edition v.1.20.2

+ The new CommandTimeout property is added to DevArt MyDAC metadata provider.
- Scrolling of partially visible items before check in DataSource check list box
  is handled correctly now.
= Aliases are emitted in the Order By clause when possible.
= French localization is updated.

April 07, 2013

Active Query Builder VCL Edition v.1.20.1

= Compatibility with the latest DevExpress VCL controls is made.
+ The new properties are added to items of the TacStatisticsOutputColumns
  collection: ObjectNameInQuery and ColumnNameInQuery. 
- MS Access: Support of TRIM builtin function is added.
- Incorrect loading of complex conditions fixed
- Interbase: Parsing some builtin functions is fixed.
- Interbase: EXTRACT function is supported.
= FIBPlus package references are updated.
= FireDAC mentioned in AnyDAC package descriptions and in installer
+ Oracle: Named parameters in function calls are supported now.
- Oracle: resolve ambiguity in parsing qualified column name with method call
- Oracle: Support of CONNECT_BY_ROOT and preserving order of START WITH/CONNECT
  BY is made.
= PostgreSql: Some date/time and system functions like CURRENT_DATE or USER
  could not be quoted. Fixed now.

February 28, 2013

Active Query Builder VCL Edition v.1.20.0

+ Greek translation is added.
+ The new "Add Union Sub-query" button is added to the Union navigation bar.
+ The new button is added to each datasource to collapse/expand it's field list.
= NexusDB3 connectivity package is updated to refer to the latest version.