Downloads

Active Query Builder VCL Edition History

August 02, 2016

Active Query Builder VCL Edition v.1.26.25

+ The new property is added to determine permanent visiblity of Delete row
  button in the first column of the Query Columns list: TacQueryBuilder
  .SelectListOptions.ToolbarDeleteAlwaysVisible.
- SQLite: Support for CHAR builtin function is added.

July 29, 2016

Active Query Builder VCL Edition v.1.26.24

- Parsing of queries with grouping or ordering by integer constants is fixed.
  (treat them as column references)
= Query Columns List: Inplace editor is still visible now when focus is lost.
- PostgreSQL: User-defined prefix operator precedence is fixed.
- Fonts aren't scaled now if ParentFont is set.

July 15, 2016

Active Query Builder VCL Edition v.1.26.23

- If word wrapping is enabled by the RightMargin property, wrapped text 
  is properly indented now.
- Informix: Support for date builtin functions like YEAR is fixed.
- MS SQL Server: Support for new DatePart items (ISO_WEEK, TZOffset, ...) 
  is made.
- The PropertiesXml property of QueryBuilder and PlainTextSQLBuilder 
  now accepts empty string.
- Focus is set to the Select List Control now when property 
  CustomExpressionBuilder.NewExpression is assigned.
- Split Panel: Bottom and top heights ratio is updated when absolute value 
  of the bottom panel height is set.

July 11, 2016

Active Query Builder VCL Edition v.1.26.22

+ New properties are added to the SelectListOptions group:
  UseCustomExpressionBuilder, DisableDirectEditingIn. Possible set values:
  acColumnExpressions - apply to Expression column, 
  acColumnConditions - apply to Criteria and subsequent columns.
+ The new DefColumnsPaneRatio and ColumnsPaneRatio properties are added
  to the TacQueryBuilder component to specify default and actual ratio 
  between size of the Design Area and the Query Columns Grid controls.
+ The Design Area and Query Columns Grid are resized proportionally now
  on rezising the control.
= The QueryBuilder.Clear method preserves design pane splitter position.
= Linked Objects menu: a table wouldn't been added to query if such 
  object already presents in this sub query.
- The SQLBuilder.IndentGlobal property is fixed now.
- Fonts are scaled according to the parent font now.
- Unnamed columns from derived tables aren't shown on the Design Pane.
- Column aliases aren't used anymore in the GROUP BY clause if server 
  doesn't support that.

June 16, 2016

Active Query Builder VCL Edition v.1.26.21

- Query layout doesn't restored from empty layout data.
- The ParseSelect now detects if given string is not a SELECT clause 
  and return different error codes and messages.
- Erroneous token number was reported incorrectly on SQL parsing error.
  Fixed now.
- TacQueryBuilder.IsSelectStatement is fixed.

May 31, 2016

Active Query Builder VCL Edition v.1.26.20

+ Support for RAD Studio 10.1 support is made.
+ Aliases are assigned now for aggregated columns.
- Add Object Dialog: Previously selected schema is restored correctly.
- Statistics isn't updated now if QueryBuilder in "destroying" state
- MS SQL Server: Parsing speed is improved.
- Loading of a CROSS JOIN in the middle of the FROM clause is fixed.

March 21, 2016

Active Query Builder VCL Edition v.1.26.19

- Changes made to criteria of invisible cells weren't applied to the query.

March 16, 2016

Active Query Builder VCL Edition v.1.26.18

- Loading of subqueries from condition cells for "IN (subquery)"
  expressions is fixed.

March 15, 2016

Active Query Builder VCL Edition v.1.26.17

= Better row height sizing in the Select List Control using custom fonts
  is made. 
- The error with quotation of sub-query text in the cells of Select List
  Control is fixed.

March 02, 2016

Active Query Builder VCL Edition v.1.26.16

+ The new property TacQueryBuilder.DatasourceOptions.TableWidthMode is added
  to determine width of new datasources on Design Pane. Possible values:
  twmFixed - fixed, specifed by the DefaultTableWidth property,
  twmAutosizeByContent - calculated to fit the while text content,
  twmAutosizeByFieldName - calculated to fit the longest field name.
- FireDAC, AnyDAC 2: CmdExecTimeout setting is fixed.
- Query Column List control: The "Sort Type" column autosize is fixed.

scroll to top
© Copyright 2005-2022 ActiveDBSoft. All rights reserved.
Site Map Terms of Use Privacy Policy

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:

News

Tweets

Testimonials

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