Visual Query Tool gives you a high-flexibility, universal tool for database querying, processing, and maintenance, based on three-level structured SQL command collections: packages, binderies, and folders.
A command is a sequence of logically binds, parameterized elementary SQL tasks, like SQL queries or DDL, DDM, or PL/SQL statements. Before execution, in order to capture the actual value of the parameters, the commands use the attached customized parameter pages. After a macro-processing phase, the enabled tasks runs, achieving the commands goal.
The results of a query can be visualized in form or browse view, as business graphics or can be saved ` at user control or based on automated mechanism ` in CSV, DBF and XML format; optionally the result set can be easy printed in a simple report form, using HTML pages.
Optionally, against unauthorized editing, the packages can be password-protected and specifying an incomplete connection, it is possible to disable the unauthorized execution `` at runtime the ODBC will ask for the lack elements.
The hand-on set of tools includes an SQL Editor, Database Structure Inspector, Parameter Enumerator, New-Application Template Manager, a Visual Parameter Page Designer and an ODBC Connection Manager too.
The automating the jobs is possible using the scheduling of Enterprise edition.
|
