Below is the list of fixes and improvements in Active Query Builder VCL Edition v.1.16.18.
+ SQLite: The component can load foreign keys now. = SQLite: The list of aggregates and built-in functions is filled now. + The new TacQueryBuilder.LinkOptions.CreateLinksByIdenticalFieldNames property is added to instruct the component to add links between objects by identical field names (might be useful for legacy databases without foreign keys). + The new TacBaseSyntaxProvider.CreateWhereJoinsByDefault property is added to instruct the component to create joins in WHERE clause, not using the JOIN keyword in FROM clause. Useful for Oracle databases when you want to use Oracle style joins (+=, =+). = Preserving additional ORDER BY attributes like "ORDER SIBLINGS BY" is made. = Turkish.lng: correct order of params in "Unexpected token" error message - Localizer "out of range" error when saving files is fixed. - The component will not try to load fields from database now if they already loaded during execution of the DoObjectMetadataLoading event handler. - MS SQL Server: Support of the OPENQUERY function is fixed. - Few CTE bugs are 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!