Active Query Builder VCL Edition History

January 26, 2011

Active Query Builder VCL Edition v.1.16.1

= Packages for Delphi 6 Enterprise IDE are included.
- MySQL: "Datetime" is now valid identifier.
+ Conditional define is made to support ExpressPageControl v3 (currently BETA)
  in acQBControls.pas,  TacPageControlBase.GetBorderWidth function.
= MySQL: GROUP_CONCAT is added to the list of aggregate functions now.
+ DB2: tuples are supported now.
= Access: Original database object fields order is restored now.

January 21, 2011

Active Query Builder VCL Edition v.1.16

+ Now it's possible to rename and remove CTE sub-queries from the query using
  the sub-query tab context menu.
+ Parsing of derived tables without aliases is possible now.
+ Oracle: Extract function for XML queries is supported now.
+ MySQL: REGEXP and RLIKE functions are supported now.
- The expressions with fields from sub-query are deleted now if these fields are 
  removed from respective sub-query (applied to all types of sub-queries).
= Better DevExpress Skins support is made for Datasource windows.
- Minor changes in the properties dialogs are made. 
- Wrong cast while processing the "not(not expression)" is fixed.
+ Fixup (determination of the field's ownership to a database object) by
  object's base name is made. (e.g. "select from db.schema.orders")
- Height calculation of the Link Properties form is fixed.
- MySQL: The differences between mysql.atg and mysql_ansi.atg are eliminated.
= The FROM keyword is always generated now for Oracle and DB2 dialects as it is
  mandatory there.

December 01, 2010

Active Query Builder VCL Edition v.1.15.24

+ Renaming of CTE is possible now.
+ Caption of the CTE subquery tab is taken from the CTE name now.
+ Addition of recursive CTE is allowed only for specific servers now.
+ Query-unique names are generated now for CTE and derived tables.
+ Server version autodetection for MS SQL, MySQL, Oracle, Sybase ASA/ASE,
  Informix is made.
+ Firebird: DateAdd, DateDiff, Overlay, Position builtin functions are added.
+ Oracle: RANGE added to the list of valid identifiers.
+ Access: The dollar sign ($) is turned to invalid letter for identifiers,
  built-in functions are added.
+ Oracle: Loading of materialized views is made.
- Field sorting is reverted to original order now when flsNone value is 
  assigned to the FieldsListOptions.SortType property.
- Query properties dialog forms look better now with DevExpress controls.
+ The new flag functions are added to the TacSubQuery class to determine if a 
  sub-query is derived table or CTE: IsSubQueryDerivedTable, IsSubQueryCTE.
+ Syntax Providers: The new server flag is added to determine if database 
  server supports recirsive CTE or not: IsSupportRecursiveCTE.
= Metadata Loading Wizard: Loading metadata is split to 3 separate stages:
  Load Objects, Load Relations and Load Custom Aggregates. This allows to 
  bypass the unnecessary steps in case of failure.
- Exception on using virtual fields in virtual objects is fixed.

November 10, 2010

Active Query Builder VCL Edition v.1.15.22

+ TacDatasourceGroup: The new methods GetLinks and GetLinksRecursive are added.
+ Oracle: CURSOR expressions are supported now.
= Empty union groups are removed automatically now after user's changes at the
- Oracle: Filtered metadata relations loading is fixed.
- Oracle: Aggregates list is corrected.
- Oracle: DB Links syntax is fixed.
- Conditions are converted correctly from HAVING to WHERE clause now on 
  clearing aggregate for a column.
- EvevateDB v2 Unicode support is fixed.
- Installer: MicroOLAP DACs package detection mistype is corrected.
- Installer: Link to Alternate Names Demo in the start menu is added.

October 07, 2010

Active Query Builder VCL Edition v.1.15.21

+ Delphi XE is supported now.
+ Bulgarian translation is added.
+ Oracle: Metadata filtration is now applied to relations fetch queries.
+ MS SQL: INDEX join hint is fixed.
+ Re-sorting fields in datasource field lists is made on changing sort mode.
- Firebird: UPPER built-in function support is fixed.
- MS SQL: Parameter names can include special symbols now (@, $, _ and #).
- MySQL: CONVERT function is fixed.

July 06, 2010

Active Query Builder VCL Edition v.1.15.12

+ German translation is updated.
+ French translation is updated.
- MS SQL Server: Special chars in parameter names (_,@,...) are accepted now.
+ Derived table alias is shown in the query structure tree instead of entire 
  SQL text.

May 05, 2010

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.

April 23, 2010

Active Query Builder VCL Edition v.

+ 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.

April 16, 2010

Active Query Builder VCL Edition v.

+ 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)")

April 08, 2010

Active Query Builder VCL Edition v.

+ Better support of recursive CTE is made.

Product Summary

 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!

Social networks