Download User Reference Guide - MSC Fileman 22.2 Documentation

MSC Fileman 22.2 User Reference Guide
Part 4: Computing Data
#) in fname.
Use:
This function returns the nth entry in a file or in a
Multiple identified by fname. If the second format is
used, the value of the specified field associated with the
nth entry in fname is returned. The nth entry is
determined by the internal entry number; the function
does not analyze the values of the entries. When used
with the second format, the nth subentry with a non-null
value is returned.
Examples:
2ND(DIAGNOSIS) => Angina Pectoris [the second entry
in the DIAGNOSIS Multiple]
10TH(ADMISSION:ADMISSION DATE) => JAN 2,1990
[ADMISSION DATE associated with the tenth
ADMISSION]
NEXT
Format:
NEXT(field)
Parameters:
field is a field's number preceded by a # or a field's label
from the current file or Multiple.
Use:
This function returns the value for the field identified by
field in the next entry. The next entry is determined by
internal entry number. No analysis of the value of entries
is done. If there are no more entries, the function returns
null.
Example:
NEXT(AGE AT ONSET) => 56 [the value of AGE AT
ONSET for the next entry in the Subfile]
PREVIOUS
Format:
PREVIOUS(field)
Parameters:
field is a field's number preceded by a # or a field's label
180
January 2015