Below is the list of fixes and improvements in Active Query Builder VCL Edition v.1.28.4.
= Index numbers in ORDER BY are converted to corresponding expressions now. = PostgreSQL parser has been optimized. - DB2: Parsing of FOR UPDATE, FOR READ ONLY, ISOLATION and OPTIMIZE FOR in an arbitrary order has been fixed. - Oracle, MySQL, MS SQL Server: Several SQL parsing fixes have been made. = FireDAC: Fetching of databases and schemas is supported now. + FireDAC The new TacFireDACMetadataProvider.LoadStoredProcedures property (default false) has been added. It instructs to load stored procedures from the driver. Turn it on only for the database servers which support using them in the FROM clause of the SELECT statement.
[ 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!