Active Query Builder VCL Edition History

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.

February 20, 2016

Active Query Builder VCL Edition v.1.26.15

= MS SQL Server: Parsing performance is improved.
- Query Columns List: The fix for "Aggregate" and "Grouping" columns
  auto-fit is made. 

February 15, 2016

Active Query Builder VCL Edition v.1.26.14

+ The new property is added to the TacCustomExpressionEditorParams object
  to determine the index of condition/or column: ConditionIndex. 
+ Fitting of the Query Column List's column width on double clicking on
  the column splitter is made.
= Addition or modification of expressions via the OnCustomExpressionEditor
  event handler now follows the same rules as changing them via the query
  building UI by end-user. (eg. checking of the Visible field for new rows,
  assigning aliases to resolve column name conflicts, etc.)

February 10, 2016

Active Query Builder VCL Edition v.1.26.13

+ The new SQL syntax feature to use aliases in GROUP BY is added:
  TacBaseSyntaxProvider.IsSupportGroupByAlias property.
= Firebird: Domain name is shown now instead of type name in datasource
  field lists.
- Database Schema Tree wasn't scrolled to the top after reload. Fixed now.
- The SubQuery.Clear clears the WITH clause as well.

February 02, 2016

Active Query Builder VCL Edition v.1.26.12

= Design Pane: Aggregated fields are checked now in Datasource controls.
- The TAB key behaviour in the last column of Select List is fixed.

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:



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