Visual Query Tool - Pro 2.0 Pro

Visual Query Tool - Pro 2.0 Pro

There are some basic functional differences between standard and professional version. These can be summarised in the following table: Iterative SQL processing The Commands can be defined not only like a simple sequence of parameterized SQL ...

Visual Query Tool - Pro Publisher's Description

There are some basic functional differences between standard and professional version. These can be summarised in the following table:
Iterative SQL processing
The Commands can be defined not only like a simple sequence of parameterized SQL tasks, but it is possible for each task of type 'Iterate' to nominate a DBF source; this task will be executed for each record of the database.
Before execution after the macro-processing of User Interface's parameters, the text of an Iterate SQL task is macro-processed, replacing each DBF field reference with the corresponding value of the field.
The task processed in this way will be executed for each record of the nominated database. For nominate a DBF there can be used a special interface control, named Iterate File Picker.
Scripting Extension
A new task type is defined: DBScript. In Essence the used language is the same as VO Scripting. This is characterised by the followings:
Full object-oriented language, with access to predefined classes
Clear philosophy in variable scoping
Full DBF processing
Access to functions and functionality at OS level
It is possible to launch external programs working in dynamically specified directories with dynamically built parameter lists
At basis it is included a simple interface for full e-mail processing like sending, receiving, extracting attachments - using the Windows Simple MAPI interface