VA FileMan V. 22.0 Getting Started HTML Manual Banner

 

Contents: Main Chapter See Also: Getting Started Manual Programmer Manual

VA FileMan Functions

LAST

Format:
  1. LAST(fname)

  2. LAST(fname:field)
Parameters:
  1. In the first format, fname is the name of a file or of a Multiple-valued field in your current file.

  2. In the second format:

    • fname is the name of your current file or Multiple.

    • field is the name of a field (or a field number preceded by #) in fname.
Use: This function returns the last entry in a file or in a Multiple identified by fname. If the second format is used, the last entry with a non-null value in field is returned. The last entry is the one with the highest internal entry number; the function does not analyze the values of the entries.
Examples:

LAST(DIAGNOSIS)=> Sepsis [last entry in this Multiple field]

LAST(DIAGNOSIS:OCCURRENCES)=> 3

 

Reviewed/Updated: March 4, 2007