Active Query Builder History v.1.14.14.0
+ Spanish and russian translations are updated.
+ The new property is made to accept tabs in the columns pane.
IActiveQueryBuilderXControls.SelectListOptions.AcceptTabs: VARIANT_BOOL
(default true)
+ Firebird: "IS DISTINCT FROM" operator is supported now.
+ Signed .Net interop assemblies are added to the installation package.
+ MS SQL Server, Sybase: Support of the old-style TransactSQL outer join
operators ("*=" and "*=") is made.
+ Aliases for virtual calculated fields are added automatically now if they
aren't defined by the user.
+ The new property IActiveQueryBuilderX.MetadataXmlFile is added to be able to
define it without JavaScript coding.
+ Firebird: Predefined context variables are supported now: CURRENT_DATE,
CURRENT_TIME and CURRENT_TIMESTAMP.
- The component doesn't trim right spaces when creating field's aliases from
alternate names now.
- MySQL: Better support of CONVERT function is made.
- PostgreSQL: Metadata filtration is fixed.
- The LayoutSQL property does not expand virtual fields and objects now.
- Create derived table access violation is fixed now.
- Sybase ASE: Relations metadata loading is fixed now.
- Assertion failed when syntax provider is changed. Fixed now.
Active Query Builder History v.1.11.8.208
+ The new properties are added to the QueryBase 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').
- The AfterPropertiesDialog event was firing even if the dialog has been
canceled. Fixed now.
Active Query Builder History v.1.2.3.1023
+ MS SQL: support for old-style TransactSQL outer joins: "*=" and "*=" operators. (only if ServerVersion < MSSQL2005) + Sybase: support for old-style TransactSQL outer joins: "*=" and "*=" operators. + MS SQL: Constants for SQL Server 2008 are added.
Active Query Builder History v.1.11.6.206
= DevExpress dependencies are updated to v9.2.9.0. + MS SQL: support for old-style TransactSQL outer joins: "*=" and "*=" operators. (only if ServerVersion < MSSQL2005) + Sybase: support for old-style TransactSQL outer joins: "*=" and "*=" operators. + MS SQL: Constants for SQL Server 2008 are added.
Active Query Builder History v.1.2.2.1022
= Active Query Builder automatically generates aliases for virtual calculated fields if they have no alias defined. - Firebird: Support of predefined context variables (CURRENT_DATE, CURRENT_TIME, CURRENT_TIMESTAMP) is added.
Active Query Builder History v.1.11.5.205
+ WPF Demo project is added. Active Query Builder is used there in a WPF window through the WindowsFormsHost. - An exception when using Active Query Builder through the WindowsFormsHost is fixed. = Query builder now automatically generates aliases for virtual calculated fields if they have no alias defined. - Firebird: Support of predefined context variables (CURRENT_DATE, CURRENT_TIME, CURRENT_TIMESTAMP) is added.
Active Query Builder History v.1.2.2.1021
+ The new property is/setLoadJoinsFromWhereClause() is added to instruct the Query Builder to not treat expressions like "tbl1.FieldName = tbl2.FieldName" as joins. They will be loaded as generic WHERE clause expressions instead. + The new method getSchemaNames() to retrieve list of database schemas is added to syntax providers. - LayoutSQL now saves SQL without virtual objects expansion. - Virtual objects can have empty aliases. If alias is empty, AQB creates one from the virtual object name. - Metadata relations loading from Sybase ASE is fixed. - DB2: Metadata filtering is fixed. - DiagramObjectDeleting event was not fired when closing a diagram object through its context menu. Fixed now.
Active Query Builder History v.1.14.4.0
+ New feature: Virtual database objects and fields. It allows to hide complex expressions and sub-queries back of ordinary fields and save derived tables as ordinary database objects. + 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 expressions like "tbl1.FieldName = tbl2.FieldName" as joins. They will be loaded as generic WHERE clause expressions instead. - Metadata relations loading from Sybase ASE is fixed. - The TacQueryBuilder.TreeOptions.TreeWidth and TacQueryBuilder.TreeOptionsMetadata.TreeWidth properties are reflect changes in UI immediately now. - DB2: Metadata filtering is fixed. - The bug with drawing of table headers when compiled by lower versions of Delphi is fixed. - Subquery tab doesn't disappear when user closes a derived table. Fixed now.
Active Query Builder History v.1.14.4.0
+ New feature: Virtual database objects and fields. It allows to hide complex expressions and sub-queries back of ordinary fields and save derived tables as ordinary database objects. + 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 expressions like "tbl1.FieldName = tbl2.FieldName" as joins. They will be loaded as generic WHERE clause expressions instead. - Metadata relations loading from Sybase ASE is fixed. - The IActiveQueryBuilderX.TreeOptions.TreeWidth and IActiveQueryBuilderX.TreeOptionsMetadata.TreeWidth properties are reflect changes in UI immediately now. - DB2: Metadata filtering is fixed. - Subquery tab doesn't disappear when user closes a derived table. Fixed now.
Active Query Builder History v.1.11.4.204
- Hotfix for LayoutSQL is made. - DiagramObjectDeleting event was not fired when closing a diagram object through its context menu. Fixed now.
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!