Active Query Builder  »  SQL Query Builder  »  SQL Query Builder for Delphi

Professional VCL Subscription

The Professional VCL Subscription additionally includes several visual controls to build professional SQL query building environment.

Advanced SQL Text Editor

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

Experienced query writers won't usually need a visual query builder to write a query. They can use it to represent a query visually in order to understand its structure. For such users a powerful text editor is of high importance. The Professional version of Active Query Builder includes SQL text editor with such essential features as code completion and syntax highlight. It uses Active Query Builder's parsing engine to determine the current context and display the proper completion lists.

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

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