FILTERING:

If you want to pick out only certain records from the current database
file (all people named "Jones" for example) you can use dBworxPE's
filtering ability.  Select the "Records" menu and click on "Set Filter".
A pop-up screen will appear where you can choose whether you want
to select a range of records, set a filter condition, filter by 
selection or run a filter 'script'.

If you choose to select a range of records, dBworxPE will ask for the
beginning and ending record numbers and then build a filtered set of
just those records.

If you choose to set a filter condition (a specific piece of text or a 
particular value that you want to match to) a setup screen will
display where you can enter the text you want to filter on and the 
fields you want dBworx to search through to find that text.

You can also match the contents of your search field against the
contents of another field in the file -- just right-click on any of the 
"Available Fields" and the name of the field you want to match against
will appear in the "Filter text/Field" box.

Using the example above you could enter "Jones" under "Filter 
Text/Field", then click "OK" and dBworx would search through the file
and select every record containing the text "Jones" (in any field).
  
If you want to confine the search to a particular field (such as "Last
Name"), you can click on any available field (listed in the box on the
left side of the screen) and it will appear in the box on the right side of
the screen.  Then click "OK" and dBworxPE will run the filter based on 
the contents of the field you selected.

Also, if you set a filter based on a specific field you have the option to
search for all records which have a value in that particular field that is: 
 
Less than the filter text (or contents of the filter field)
  
Equal to the filter text (or contents of the filter field)
  
Greater than the filter text (or contents of the filter field)
  
Not Equal to the filter text (or contents of the filter field)
So if you want to pull all records that have a department number 
between 4 and 9 you could set a filter for all records with department 
number greater than 3, then run a second filter for all records with a 
department number less than 10.

In any case once you click "OK" the main screen will reappear, 
showing just those records that matched your criteria.  At that point 
you can do one of several different things:

  1) Save the results - Select the "File" menu, click on "Save As", 
      enter a file name and the filtered records will be saved as a 
      new dBworxPE file.

  2) Run an additional filter following the same steps as you did the
      first time (this allows you to run complex filters based on multiple 
      search criteria).

  3) Remove the filter -- select the "Records" menu and select 
      Remove Filter".

Filtering by selection:
To filter by selection, just click on the checkmark box at the 
front of each record you want to include in the result set.  Then
click on the "Records" menu, select "Set Filter", and click on 
"Filter by selection".  dBworxPE will automatically remove any 
records that are not checked.

Filter scripts: 
In addition to selecting a range of records or setting a filter
condition, you can also select to run a filter 'script' file.  Script
files give you increased flexibility in creating a filter; they allow
you to define multiple conditions involving multiple fields.

For example, if you have the "contax" database loaded and want to 
filter out everyone but one particular person (say, Dave Morgan),
you could create a script file (using dBworxPE's built-in Editor or
any other text editor) as follows:

First Name
=
Dave
AND
Last Name
=
morgan
END

This script tells dBworxPE to pick only those records that have a
first name equal to "Dave" AND a last name equal to "Morgan" (note
that the filter is not case sensitive).

You could do just the opposite (create a filter set that contains
everyone BUT Dave Morgan) by using the following script:

First Name
<> 
Dave
OR
Last Name
<>
Morgan
END

Suppose you wanted to filter out everyone but Dave Morgan and his
wife, Karen Morgan:

Last Name
=
Morgan
AND
First Name
=
Dave
OR
First Name
=
Karen
END

Notice that each script consists of a series of statements, each of
which is made up of four parts: the field name to search (such as
'First Name'), the desired condition (= or <>), the text to match
against the field value ('Morgan'), and a logical operator.  You
add an 'AND' or 'OR' between each set of conditional statements,
indicating whether the two statements both have to be true or if
only one of them has to be true. If there are no more statements,
just enter "END" as the last logical operator.

Finally, all filter scripts end with the extension ".dws" - so if 
you create a script named "custfilter" for example, be sure that
you add the .dws extension - making the actual file name 
custfilter.dws".