We're glad to announce the new minor version of Active Query Builder VCL Edition. You can evaluate the new version by requesting the trial. Customers can download the new version in the Customer's area.
What's new in the Active Query Builder VCL Edition version 1.30?
Work with complex SQL scripts using the new TacSQLScript component: look through, add, remove and edit separate statements.
Skip SET, DECLARE and other statements preceding the first SELECT statement by attaching the new TacSQLScriptBuilderPlainText component to the TacQueryBuilder component.
Apply values to parameters and cut off unneeded parameters from queries, get ready-to-use TDataset objects with the help of the new TacQueryParametersTransformer component.
Now you can build a query with plenty of parameters for all occasions and let the user choose what he/she needs at the moment.
You can replace parameters in the query text with scalars, lists, complex SQL expressions, and sub-queries.
A frequent scenario is to substitute a single parameter for a list of values in a condition with the IN operator.
Active Query Builder ensures the validity of the resultant query text by checking macro values before the replacement to protect from SQL injection.
Comments by Disqus:
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!