Make queries easy, flexible and powerful.

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

http://www.tmssoftware.com

Download File Size:9.09 MB

---