VA FileMan V. 22.0 Programmer Manual Banner


 

Main Chapter Getting Started Manual Advanced User Manual

Database Server (DBS) API


VALUES^DILF( ): FDA Values Retriever

This procedure returns values from an FDA for a specified field. The IENS associated with a particular value is also returned. Use $$VALUE1^DILF if you want the single value associated with a particular file and field in a standard FDA.

Format
VALUES^DILF(FILE,FIELD,FDA_ROOT,.RESULT)
Input Parameters
FILE

(Required) File or subfile number.

FIELD

(Required) Field number for which data is being requested.

FDA_ROOT

(Required) The root of the FDA from which data is being requested.

.RESULT

(Required) Local array that receives output from the call. The array is killed at the beginning of each call. See the "Output" below, for the structure of the array.

Output

See the .RESULT input parameter.

The output from the call is returned in the array identified by RESULT. Its structure is:

RESULT Number of values found for the specified field. If no node exists in the FDA for the field, RESULT=0
RESULT(seq#) Value for a particular instance of the field. Seq# is an integer starting with 1 that identifies the particular value
RESULT(seq#,"IENS") The IENS of the entry or subentry with the value in RESULT(seq#)
Example
    >ZW MYFDA
    MYFDA("DATA",16200,"33,",4)=FREE TEXT DATA
    MYFDA("DATA",16200.04,"1,33,",1)=16
    MYFDA("DATA",16200.04,"2,33,",1)=45
    
    >D VALUES^DILF(16200.04,1,"MYFDA(""DATA"")",.MYVALUES)
    
    >ZW MYVALUES
    MYVALUES=2
    MYVALUES(1)=16
    MYVALUES(1,"IENS")=1,33,
    MYVALUES(2)=45
    MYVALUES(2,"IENS")=2,33,

Error Codes Returned

None


VA Home Page / OI Home Page / HSD&D Home Page/ Site Map / Terms of Use / VA Privacy Policy

Reviewed/Updated: July 24, 2003

If you have questions, need more information, or are having accessibility problems with this website, please contact us by E-Mail: Reviewed/Updated: March 10, 2007