Active Query Builder  »  News  »  Active Query Builder VCL and ActiveX Editions News

July 21, 2017

Active Query Builder Professional VCL Subscription is available now.

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:

Visual Query Builder

The same powerful control for visual design of SQL queries as in the Standard VCL Subscription.

SQL Filter Builder

A new visual control to specify additional filters for arbitrary SELECT statement. (TacCriteriaBuilder)

• Presents conditions in a form close to natural language.
• Lets define the unlimited depth of nested criteria groups to combine AND and OR operators.
• Lets define various types of conditions for columns of original SQL query taking their data types into account.
• Allows for browsing for existing values of a field and data in related objects for foreign key fields.
• Lets define free-form conditions by typing arbitrary logical SQL expressions (can be disabled).
• Can be collapsed to free some space for other controls on the form. Being collapsed displays the filter string.
• Saves state to an XML string to restore on the next work session.

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.

Advanced SQL Text Editor

A fully functional text editor for editing text SQL queries and SQL scripts.

Main features:

• Customizable SQL syntax highlighting.
• Code completion, taking the current SQL syntax into account.
• Search and replace in the text.
• Gutter with line numbers.
• Word wrapping.
• Splitting SQL scripts by statements.
• Folding SQL statements in scripts.

SQL Expression Editor

A handy dialog for easy editing of big SQL expressions in the Expression and Criteria columns of the Query Columns List.

• Built on the base of the SQL Text editor.
• Displays lists of tables and columns used in the current sub-query for easy addition to the text of expression.
• Displays database schema tree, lists of functions, and other useful information in the left side panel.
• Easily integrated with the Query Builder by setting a single property (QueryBuilder.ExpressionEditor).

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.

Author: Sergey Smagin at ActiveDBSoft.

» All Active Query Builder news

Comments by Disqus: