Below is the list of fixes and improvements in Active Query Builder VCL Edition v.1.30.0.
Standard edition: + The new component TacSQLScript splits the query by statements, allows to look through them and edit separate statements in it. + The new TacQueryParametersTransformer component is added to: 1. cut off conditions with undefined parameter values, 2. convert parameter notation to the colon-prefixed notation. = Query Columns List: Handling of incomplete strings in expression cells has been improved. - PostgreSQL: Support for WITH clause in subqueries has been added. Professional version: + The new TacQueryParametersTransformer is also capable to deal with macros. Using it you can replace a single parameter with a list of values, SQL expression or sub-query. + SQL Text Editor: The suggestion list now works smoothly, filters items to suggest smarter and loads the needed metadata in a thread. + SQL Text Editor: New properties have been added to tune colors and suggestion behavior. + SQL Text Editor: Highlights the current SQL statement and provides methods to get and set the current SQL statement. = SQL Text Editor: Other fixes and usability improvements have been made.
[ 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!