We are glad to present the new long awaited Professional VCL Subscription package which allows building a professional user interface to work with SQL queries and data.
The Professional VCL Subscription includes the following visual controls:
The same powerful control for visual design of SQL queries as in the Standard VCL Subscription.
A new visual control to specify additional filters for arbitrary SELECT statement. (TacCriteriaBuilder)
This control is a user interface for the well-proven non-visual TacQueryTransformer component which performs various changes with the query: changes sorting, hides and renames columns, calculates aggregated values for result query dataset.
It was primarily made to let users make changes to the query while browsing the result query data, so placing it above the data grid will let you make a robust end-user interface to work with data. You can set handlers for user clicks on the grid column headers to change the sort order, and define other handy ways to sort and filter data. For example, you can set a context menu for grid data cells and let define filters for specific column and value (is equal, is not equal to). All of that settings will be processed by the TacQueryTransformer object (and reflected in the Criteria Builder) which will produce a new query to execute and display it to the user.
A fully functional text editor for editing text SQL queries and SQL scripts.
A handy dialog for easy editing of big SQL expressions in the Expression and Criteria columns of the Query Columns List.
The trial version can be downloaded from the download page.
Existing customers can upgrade to the new subscription for the price difference between subscriptions in the Customer's area.
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!