SUPPORT

• Tips & FAQ
• Product manual (343.09 KB)
• Contact Support

TRIAL DOWNLOADS

• Delphi 5 (2.10 MB)
• Delphi 6 (2.15 MB)
• Delphi 7 (2.14 MB)
• Delphi 2005 (2.18 MB)
• Delphi 2006 (2.67 MB)
• Delphi 2007 (2.65 MB)
• Delphi 2009 (2.69 MB)
• Delphi 2010 (2.74 MB)
• Delphi XE (5.47 MB)
• Delphi XE2 (2.64 MB)
• C++Builder 6 (2.64 MB)
• C++Builder 2006 (2.67 MB)
• C++Builder 2007 (2.65 MB)
• C++Builder 2009 (2.69 MB)
• C++Builder 2010 (2.74 MB)
• C++Builder XE (5.47 MB)
• C++Builder XE2 (2.64 MB)

Purchase a license

BOOKMARKS

TMS Query Studio

Make queries easy, flexible & powerful.

• Feature overview
• Version history
• Tips & FAQ
• Purchase a license

Feature overview

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.

Feature details

• Visual definition of SQL, in a natural language-like way
• Localization support to easily translate all user interface elements
• 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, AnyDAC, Oracle, MySQL, Nexus, Interbase, DBISAM and Local BDE
• Automatically set TDataset properties. Supports BDE, ADO, AnyDAC, IBX, DBISAM, Nexus, IBO, DirectSQL and DBExpress dataset descendants
• Automatic grouping feature for aggregate functions usage
• Support custom field expressions and custom filter conditions

Buy online

This product is also available in the following bundle(s):

1. TMS VCL Subscription

TMS VCL Subscription
for Delphi 5, 6, 7, 2005, 2006, 2007, 2009, 2010, XE, XE2, C++Builder 5, 6, 2006, 2007, 2009, 2010, XE, XE2
View licensing FAQ
1. License for commercial use: Single developer license, Small team license, Site license
2. Includes full source code
3. Free 2 year updates and new releases
4. Free priority support through email, newsgroup and forum
€ 695
Single developer license
for 1 developer
order now or add to cart

€ 995
Small team license
for 2 developers
order now or add to cart

€ 2495
Site license for unlimited
developers in the company
order now or add to cart