Query Studio provides a simple means to provide users access to powerful queries without understanding SQL. Users can set up complicated questions in a nearly natural language manner with Query Studio. Dropping the part VisualQuery on the shape and link with the database opens the visual question power of Query Studio.
TMS Query Studio Great Features:
- Visual definition of SQL, in a natural language-like manner
- Localization helps to translate all user interface components readily.
- Enables definition of source tables and unites
- Enables definition of filtering and order
- Exclusive parameter editors comprise a value in the filter condition that could be connected to some parameter editor. End-user can alter editor worth, and It Is Going .to be revealed in SQL automatically
- Supports SQL syntax for Microsoft Access, Microsoft SQL Server, AnyDAC, Oracle, MySQL, Nexus, Interbase, DBISAM, and Neighborhood BDE
- Automatically set TDataset possessions. Supports BDE, ADO, AnyDAC, IBX, DBISAM, Nexus, IBO, DirectSQL, and DBExpress dataset descendants
- Automatic grouping attribute for aggregate purposes use
- Support custom area sayings and custom filter requirements