Active Query Builder VCL Edition v.1.15.7
+ New internal methods to work with datasets are made. Now most of metadata retrieval requests return results in unidirectional read-only datasets. - MS SQL Server: Char and Nchar built-in functions parser ambiguity is fixed. - Firebird/InterBase: Parsing queries with parentheses in FROM clause are fixed. - CTE in derived tables are fixed one more time.
Active Query Builder VCL Edition v.1.15.6.0
+ Oracle: Global pipelined functions can be added from the database objects tree to the query building area. - More reliable object prefix skipping and names fixup in derived tables is made.
Active Query Builder VCL Edition v.1.15.5.0
+ Small SQL92 grammar fixes are made.
- The component doesn't generate empty string anymore if WITH clause items
exist in a query.
- TacQueryBuilder.PropertiesXML property is fixed for Delphi 2010.
- Wrong name references fixup in CTE subqueries is fixed.
- Wrong links relocation in complex FROM clauses with many parentheses on
datasource/link deletion is fixed.
- MS SQL Server: Field aliases for table-valued functions are allowed now.
("select t.f1, t.f2 from TVF() as t(f1,f2)")
Active Query Builder VCL Edition v.1.15.4.0
+ Better support of recursive CTE is made.
Active Query Builder VCL Edition v.1.15.3.0
- Explicit DevExpress styles definition is removed when Skins are enabled.
This allows skin drawing the background.
- MS Access: Built-in function names are removed from the list of correct
identifiers.
- Assertion failure error when you use alias same as object name is fixed now.
(select * from Orders Orders)
- A better fields list in WITH clause support is made.
- Installer: Delphi 5 detection is fixed.
+ New toolbar buttons in the Main demo demonstrate some standard query builder
operations, such as Add new object, Edit query properties, etc.
+ List of existing Common table expression is added to the "Add CTE" submenu.
+ SQLite: Support of string concatenation operator is made ("qwe" || "asd")
= Informix: Better server autodetection is made.
- AutoSyntaxProvider: Unnecessary server auto-detection is disabled for the
Universal syntax.
Active Query Builder VCL Edition v.1.15.0.0
+ 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. + The new demo is added to demonstrate Virtual Objects And Fields feature. + The new demo is added to learn about Drag'n'Drop functionality. = ParenthesizeSingleCriterion property is applied now to join conditions. - Bug fixed: Wrong names fixup for select items like "table.*" if more than one "table" objects were used in the query. - Firebird: Parameter names can use the '#' symbols now. - The WorkOffline property wasn't taken into account when loading fields for stored procedures. Fixed now. - MS Access: Bug with unsupported FULL OUTER JOIN is fixed. - PostgreSQL: The list of unifying operators is fixed. - MS Access: "NULL" is excluded from the list of valid identifiers. = Internal parser objects caching is turned off as it's not necessary for modern Delphi versions. + AnyDAC 2 metadata provider is made.
Active Query Builder VCL Edition v.1.14.14.0
+ 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').
+ Aliases for virtual calculated fields are added automatically now if they
aren't defined by the user.
+ Firebird: Predefined context variables are supported now: CURRENT_DATE,
CURRENT_TIME and CURRENT_TIMESTAMP.
+ Firebird: "IS DISTINCT FROM" operator is supported now.
+ MS SQL Server, Sybase: Support of the old-style TransactSQL outer join
operators ("*=" and "*=") is made.
- 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.
- Popup menu for the grid inplace editor is restored now.
- 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.
Active Query Builder VCL Edition 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 VCL Edition v.1.13.21.0
+ The new methods are added to get database schemes list:
TacBaseSyntaxProvider.GetSchemaNames - for specific database servers;
TacBaseMetadataProvider.GetSchemaNames - for generic ADO connections.
+ Unambiguous reading metadata from XML generated by other AQB Editions
(.Net, Java) is made.
+ The new TacFieldsListDescriptionColumnOptions.ShowLongDescription property
is added to control which description will be shown in the Description column
of the fields list:
when it's False (default), the TacMetadataField.ShortDescription is shown;
when it's True, the TacMetadataField.LongDescription is shown.
Active Query Builder VCL Edition v.1.13.20.0
- SQLite: Fixed problem with removing of the OFFSET part of LIMIT clause in the Query properties dialog. + The new property is added to create aliases automatically based on alternate names: TacQueryBuilder.SelectListOptions.CreateColumnAliasesFromAltNames. + Firebird, InterBase: List of reserved words is imported into the grammar.
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!