Overview

TMS Query Studio provides an easy way to give users access to powerful queries without requiring any knowledge about SQL. Users can setup complex queries in an almost natural language way with Query Studio. Dropping the component VisualQuery on the form and connect to the database opens the visual query power of Query Studio.

Query Studio offers two main components:

  • TatVisualQuery component, which is a visual component with a friendly interface for end-users to build their own SQL statements.

  • TatMetaSQL component, which is a non-visual component that encapsulates an SQL statement in a object-oriented architecture.

Feature details

  • Visual definition of SQL, in a natural language-like way;

  • Allows definition of source tables and joins;

  • Allows definition of order and filtering;

  • Exclusive parameter editors feature: a value in the filter condition can be attached to a parameter editor. End-user can change editor value and it will automatically be reflected in SQL;

  • Supports SQL syntax for Microsoft Access, Microsoft SQL Server, Oracle, MySQL, Nexus, Interbase, DBISAM and Local BDE;

  • Automatically set TDataset properties. Supports BDE, ADO, IBX, DBISAM, Nexus, IBO, DirectSQL and DBExpress dataset descendants;

  • Automatic grouping feature for aggregate functions usage;

  • Supports custom field expressions and custom filter conditions.

Rebuilding Packages

If for any reason you want to rebuild source code, you should do it using the "Packages Rebuild Tool" utility that is installed. There is an icon for it in the Start Menu.

Just run the utility, select the Delphi versions you want the packages to be rebuilt for, and click "Install".

If you are using Delphi XE and up, you can also rebuild the packages manually by opening the dpk/dproj file in Delphi/Rad Studio IDE.

Do NOT manually recompile packages if you use Delphi 2010 or lower. In this case always use the rebuild tool.

Installing Database Adapters

By default Query Studio package installs only TatCustomDatabase, TADODatbase, TDBXDatabase and TatBDEDatabase (if supported) components. Query Studio also provides other database connection components, which must be manually included in package before installing, since not every Delphi environments have the specific components installed:

AnyDAC

For installing TatAnyDACDatabase in your environment, add {$QS}\source\drivers\anydac directory to the Delphi library path, where {$QS} is the root directory of Query Studio files, and include qsanydacreg.pas unit in Query Studio package.

DBISAM

For installing TatDBISAMDatabase in your environment, add {$QS}\source\drivers\dbisam directory to the Delphi library path, where {$QS} is the root directory of Query Studio files, and include qsdbisamreg.pas unit in Query Studio package.

IBO

For installing TatIBODatabase in your environment, add {$QS}\source\drivers\ibo directory to the Delphi library path, where {$QS} is the root directory of Query Studio files, and include qsiboreg.pas unit in Query Studio package.

IBX

For installing TatIBXDatabase in your environment, add {$QS}\source\drivers\ibx directory to the Delphi library path, where {$QS} is the root directory of Query Studio files, and include qsibxreg.pas unit in Query Studio package.

NexusDB

For installing TatNexusDatabase in your environment, add {$QS}\source\drivers\nexus directory to the Delphi library path, where {$QS} is the root directory of Query Studio files, and include qsnxreg.pas unit in Query Studio package.

SQLDirect

For installing TatSQLDirDatabase in your environment, add {$QS}\source\drivers\sqldir directory to the Delphi library path, where {$QS} is the root directory of Query Studio files, and include qssqldirreg.pas unit in Query Studio package.

In this section:

Components Overview

A brief summary of the installed components.

Localization

How to localize strings used in user interface.

Using Parameters

Usage of parameters in TatVisualQuery component.

TatMetaSQL Component

Component that encapsulates an SQL statement.