Download User Reference Guide - MSC Fileman 22.2 Documentation

MSC Fileman 22.2 User Reference Guide
Part 1: Reading Data
---------------------------------------------------------------FMPERWSON,ONE
FMPERSON,TWO
FEB 13,2013
JAN 16,2013
2 MATCHES FOUND.
Press RETURN to continue...
The search found two entries that matched the search conditions (i.e.,
DATE ACCESS CODE LAST CHANGED greater than 2/2/99 and ACCESS
CODE not null).
Details and Features
Sorting and Searching
As you may recall, you can print a subset of entries from a file by sorting
(i.e., printing only those entries that fall between a sort-from value and a
sort-to value). Searches also select a subset of entries from a file, although
with more flexibility than with sorting.
When you print your output from a search, you are also given a chance to
sort the output. This means that while searching selects a subset of entries
to print, through sorting you can further restrict that subset of entries that
is going to print. How does sorting affect the output of the searches?
The answer is that MSC Fileman uses both your search and sort order to
select entries. You enter the search criteria before you enter the sort order.
However, the selection of entries indicated in the sort ("START WITH …
GO TO" dialogue) sorting is done first, after which the search conditions
are applied to all remaining entries to determine the final set of matching
entries.
44
January 2015