Category : Databases and related files
Archive   : VIDLIB1.ZIP
Filename : MSELHLP.TXT

** MOVIE SELECTOR ** Page 1
------------------------------------------------------------------------------
The MOVIE SELECTOR screen is displayed if you choose to just display some
movies from the SELECT REPORT TYPE LISTING screen or if you choose to create
a Sub-File from the UTILITY screen. The purpose of this screen is to allow
you to selectively choose the movies you want included in your report or
Sub-File. Selections of the movies that you require from the library file
are made through entries in four fields.

1. Field Enter the field name on which you wish to restrict output.
In addition to the 15 field names displayed on the screen,
you may use three additional field names, STARF for the
star's first name, COSTARF for the co-stars first name,
and DIRECF for the director's first name. Using the field
names STAR, COSTAR and DIRECTOR is for their last names.

2. Comparator Requires entry of one of the comparators listed in the
screen window.

3. LogOp Requires entry of one of the logical operators (and -- or).
The word END is type in this field if the column is not
filled, to end data entry on the screen.
----------------------------------------------------------------------------
** MOVIE SELECTOR ** cont Page 2
----------------------------------------------------------------------------
4. Value Enter a constant against which you want the comparison made.

** Examples **

LogOp Field Comparator Value
____________________________________________________________________________
YEAR GE 1985
AND RATING EQ PG
AND TIME LE 100
END
This example would select those movies in your library file that were made
in or after 1985, that were rated PG and had a running time of 100 min or less.

STAR EQ EASTWOOD
OR STAR EQ REYNOLDS
AND CATEGORY EQ A
This example would select those movies in your library file that starred
either Eastwood, or Reynolds that were in the Action category.


------------------------------------------------------------------------------