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

Active Query Builder 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.

» All Active Query Builder news

Comments by Disqus:

News

Tweets

Screenshots

Join Types

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 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.


Active Query Builder Screenshots

Social networks