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:
Automatic Joins Creation
Active Query Builder automatically determines relationships between tables and creates appropriate joins for them.
Different Join Types
Active Query Builder allows to define different join types and various server-specific query options visually.
Unions and Sub-Queries
Unions, sub queries and derived tables can be accessed and built visually in Active Query Builder as easy as the main query.
Grouping, Sorting and Criteria
Active Query Builder allows to define grouping, sorting, and constructing criteria in a simple and direct way.