Active Query Builder VCL and ActiveX Editions 1.15 released
We're glad to announce the new minor version of Active Query Builder. You can download the newest version from the download page.
What's new in the Active Query Builder version 1.15?
General improvements:
New feature: Virtual database objects and fields. It allows to hide complex expressions and sub-queries behind ordinary fields and save derived tables as ordinary database objects. See the Virtual Objects And Fields source code sample for demonstration and details. See below to find the corresponding API improvements for VCL and ActiveX Edition.
Now it's possible to add Common Table Expressions visually using the context menu item of the query building area.
Wheel scrolling in field lists is made.
Spanish and russian translations are updated.
SQL Syntax fixes and improvements:
MS SQL Server, Sybase: Support of the old-style TransactSQL outer join
operators ("*=" and "*=") is made.
Firebird: Predefined context variables are supported now: CURRENT_DATE,
CURRENT_TIME and CURRENT_TIMESTAMP.
Firebird: "IS DISTINCT FROM" operator is supported now.
Firebird: Parameter names can use the '#' symbols now.
MySQL: Better support of CONVERT function is made.
PostgreSQL, DB2: Metadata filtration is fixed.
PostgreSQL: The list of unifying operators is fixed.
Sybase ASE: Metadata relations loading is fixed now.
MS Access: Bug with unsupported FULL OUTER JOIN is fixed.
VCL Edition API improvements:
New properties are added to support virtual database objects and fields:
TacMetadataField.Expression and TacMetadataObject.Expression (WideString).
TacMetadataField.Expression can contain any correct SQL expression;
TacMetadataObject.Expression can contain any correct "datasource": an SQL
expression which can be used in the FROM clause, i.e. object name, subquery
(derived table), etc.
TacSQLBuilder object will replace all mentions of such fields and objects in
result SQL with this expression. Programmer can control such expansion using
the TacSQLBuilder.ExpandVirtualFields boolean property.
The new property TacQueryBuilder.LoadJoinsFromWhereClause: boolean is added.
Using this property you can instruct Query Builder to not treat WHERE expressions
like "tbl1.FieldName = tbl2.FieldName" as joins. They will be loaded as
usual WHERE criteria instead.
The new property is made to accept tabs in the columns pane.
TacQueryBuilder.SelectListOptions.AcceptTabs: boolean; default true;
The new properties are added to the TacQueryBase class to set up the Union
operator programmatically:
UnionOperator: gets/sets the unifying operator ('Union', 'Except', 'Intersect' etc.);
UnionAllFlag: gets/sets the 'All' keyword for the operator;
UnionOperatorFull: gets/sets the full operator string (e.g. 'Union All').
ParenthesizeSingleCriterion property is applied now to join conditions.
VCL Edition other fixes and improvements:
The new demo is added to demonstrate Virtual Objects And Fields feature.
The new demo is added to learn about Drag'n'Drop functionality.
Internal parser objects caching is turned off as it's not necessary for
modern Delphi versions.
AnyDAC 2 metadata provider is made.
ActiveX Edition API improvements:
New properties are added to support virtual database objects and fields:
IMetadataField.Expression and IMetadataObject.Expression (BSTR).
IMetadataField.Expression can contain any correct SQL expression;
IMetadataObject.Expression can contain any correct "datasource": an SQL
expression which can be used in the FROM clause, i.e. object name, subquery
(derived table), etc.
The component will replace all mentions of such fields and objects in
result SQL with this expression. Read the IActiveQueryBuilderX.SQLForServer
property to get the expanded result SQL text.
The new property IActiveQueryBuilderX.LoadJoinsFromWhereClause: VARIANT_BOOL
is added. Using this property you can instruct Query Builder to not treat WHERE
expressions like "tbl1.FieldName = tbl2.FieldName" as joins. They will be
loaded as usual WHERE criteria instead.
The new property is made to accept tabs in the columns pane.
IActiveQueryBuilderXControls.SelectListOptions.AcceptTabs: VARIANT_BOOL
(default true)
The new property IActiveQueryBuilderX.MetadataXmlFile is added to be able to
define it without JavaScript coding.
ParenthesizeSingleCriterion property is applied now to join conditions.
ActiveX Edition other fixes and improvements:
Signed .Net interop assemblies are added to the installation package.
Assertion failed when syntax provider is changed. Fixed now.
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!