Wizards

Please note that the table whose record selection is initiated will already been opened by and intimated by the calling process.

This wizard will open up the following popup:

At this moment user can either suspend <ESC> or continue the process. Four options are available to the user:

Filtered Records. Vouch offers a Filter Wizard Filter Wizard which is activated on selection of this option and resulting records which meet the filter criteria thus defined are passed onto calling process.

Selective Records. This option presents a browser view of table whose record selection is sought. You can make selections by pressing <enter> and deselect the same with the same key <enter>. Left most column of the browser will depict a or similar like sign marking the selected records.

The Usage

To define filter criteria on attached databases in a report designed through Report Generator.

To supply the filter condition to 'Record Selection Wizard'.

How to define
Enter a module through main menu.
Press F.
A popup will appear as follows.

Create New Query will lead to another popup to select nature of query: 

Selective option in will clear the form and invite user to input values in the fields. A message in the message area of DEW will flash as 'Press <Ctrl+F1> to Define Range Attribute' to advanced options for each field. By default entered values are matched exactly against the table contents which can be changed to suit your requirements by pressing Ctrl_F1 after positioning the cursor on the field where it is sought, such as:

First image is valid for character fields and the next one for date and numeric fields. After putting up the values in the fields with filter attributes, Vouch bring forth a browser view of subset of table meeting given conditions, if any record is found, otherwise alerts abount its failure.

Manual option requires some programming skill though Vouch offers a state of the art Vouch Expression Builder. 

After expression is built, Vouch bring forth a browser view of subset of table meeting given conditions, if any record is found, otherwise alerts about its failure.

At final step, you will be prompted to save or not this filter definition. If your reply is positive then short name and description of the filter will be asked for something like this:

and the process will be repeated for description which will be presented while playing it. The filter definition is saved for future usage.

Play Selected Query presents all available query definitions for the module under process and by selecting one activates the filter and brings forth the browser view of subset of table.

Edit a Query is only valid for Manual Queries and steps to edit it are the same as if creating a query differing only that previous expression is visible in Expression Building Window.