E@DBFINDEQ

Name

The E@DBFINDEQ call has the following format:

DN@<Logical>(E@DBFINDEQ)

where <Logical> identifies the database file and index to use to perform the E@DBFINDEQ call.

Description

E@DBFINDEQ reads the single database record whose key fields equal the values you set in the record retrieval variables (D@ fields) corresponding to the index key fields. Because this call looks for a specific record, all D@ fields must have a value entered before performing the routine.

Input Values

Field	Description
<Index>	<Logical> identifies the database file and index to use to perform the E@DBFINDEQ call.
Record retrieval variables (also known as D@ and D# fields)	You must populate the index key fields used to locate the record before using this call.

Return Values

Field	Description
D<prefix>@NOTFOUND	Each routine sets the logical value <FileName>-NOTFOUND or <FileName>-FOUND based on the outcome of the read process. The Find routines set D<prefix>@NOTFOUND to FALSE if a record is found, TRUE if a record is not found, or E@KEY@FOUND if the keys are found.

*       Find the company record in GLMASTER.
*
      EVAL      D@CMPNY        = F1@TCMPNY                  
      EVAL      D@ACCUNT       = DGLMACCUNT                 
      EVAL      D@VRLVLS       = DGLMVRLVLS                 
      EVAL      D@ACCNT        = DGLMACCNT                  
      EVAL      D@SBACCN       = DGLMSBACCN               
      CALLP     DN@DBIFGLM1(E@DBFINDEQ)