Active Query Builder  »  News  »  Active Query Builder VCL and ActiveX Editions News

April 28, 2017

Active Query Builder VCL and ActiveX Editions 1.27 are released.

We're glad to announce the new minor version of Active Query Builder. You can evaluate the new version by requesting the trial. Customers can download the new version in the Customer's area.

What's new in the Active Query Builder VCL and ActiveX version 1.27?

  • General changes:
    • Support for RAD Studio 10.2 Tokyo has been made.
    • Polish translation has been added.
  • User interface changes:
    • Linked Objects menu behavior has been changed: a table won't be added to query if such object already presents in this subquery.
    • Automatic links creation has been improved: links are created only from Parent to Child table or vice vera, but not both at the same time.
  • SQL syntax changes:
    • SQLite: Right outer joins are converted to left joins by reordering objects in the FROM clause now.
    • PostgreSQL: Support of materialized views, TOAST tables, and foreign tables has been made.
    • PostgreSQL: Support for custom aggregate functions has been added.
    • Oracle: Calculation of SQL expression data types is made.
    • ODBC literals and function calls syntax is supported now in all SQL syntaxes.
  • API improvements:
    • Query Transformer is now capable of renaming output query columns.
    • The new TacQueryTransformer.RenameDuplicatedColumns (ActiveX: IQueryBuilder.QueryTransformer.RenameDuplicatedColumns) property prescribes to explicitly specify all the columns in the query SELECT list by expanding the asterisk items, then find and rename the unnamed and duplicated column names.
    • Autosizing of new objects being added to the Design Pane has been made. The new TacQueryBuilder.DatasourceOptions.TableWidthMode (ActiveX: IQueryBuilder.TableWidthMode) property can be set to the following values:
      - twmAutosizeByContent: width is calculated to fit the whole text content,
      - twmAutosizeByFieldName: width is calculated to fit the longest field name.
    • The new TacQueryBuilder.PartialMetadataLoading (ActiveX: IQueryBuilder.PartialMetadataLoading) property being set to True lets load metadata only for objects that were used in the query on assigning it to the SQL property.
    • The new property TSQLBuilderConditionFormat.NewLineBefore (ActiveX: ISQLBuilderSelectFormat.WhereNewLineBefore, ISQLBuilderSelectFormat.HavingNewLineBefore) has been added to add line break before each condition.
at ActiveDBSoft.
» All Active Query Builder news

Comments by Disqus:




Join Types

Automatic Joins Creation
Active Query Builder automatically determines relationships between tables and creates appropriate joins for them.

Different Join Types
Active Query Builder allows to define different join types and various server-specific query options visually.

Unions and Sub-queries

Unions and Sub-Queries
Unions, sub queries and derived tables can be accessed and built visually in Active Query Builder as easy as the main query.

Grouping, Sorting and Criteria
Active Query Builder allows to define grouping, sorting, and constructing criteria in a simple and direct way.

Active Query Builder Screenshots

Social networks