Active Query Builder History v.0.1.0
+ Ability to drop ASP.NET Query Builder to a form from the toolbox is made. + Installation package is improved to add component to the toolbox automatically. + Server error reporting is improved.
Active Query Builder History 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 History 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 History 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 History 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.
- PropertiesXML property setter is fixed.
- 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 History v.0.0.7
- Compatibility fix for VB.NET WebApplication projects for 3.5 framework.
Active Query Builder History v.1.15.4.0
+ Better support of recursive CTE is made.
Active Query Builder History v.1.15.4.0
+ Better support of recursive CTE is made. - The problem with returning wrong object type from the FieldsListOptions properties under Internet Explorer is fixed.
Active Query Builder History v.1.12.4.219
= The Connection property of IDbConnection type is added to the
BaseMetadataProvider. It allows to get the connection object from the
QueryBuilder.MetadataProvider without casting to specific metadata provider
and connection types.
= DevExpress dependencies of ActiveDatabaseSoftware.DevExpressControlFactory.dll
are updated to v9.3.4.0.
- Assertion error if using an alias the same as the object name ("SELECT * FROM
Orders Orders") is fixed.
- Fields with same names but from different tables were identified incorrectly
in some cases. Fixed now.
Active Query Builder History 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 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!