Below is the list of fixes and improvements in 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.
[ Legend: ] [ + New feature ] [ = Improved/changed feature ] [ - Bug fix ] [ ! Important notice ]
You can always get the latest trial version of Active Query Builder VCL Edition at the download page.
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!