向補習說再見

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