E@DBFINDPRVRNG

Name

The E@DBFINDPRVRNG call has the following format:

DN@<Logical>(E@DBFINDPRVRNG)

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

Description

When you need to process a range of data without interruption, use E@DBFINDPRVRNG.

Using the API in a Program

You must precede E@DBFINDPRVRNG with E@DBFINDBEGRNG, E@DBFINDSUBRNG, E@DBFINDMIDRNG, or E@DBFINDMIDSUB.

Input Values

Field Description
<Logical> <Logical> in the E@ statement identifies the database file and index to use to perform the call.
Record retrieval variables (also known as D@ and D# fields) Define the beginning and ending values of the last key by moving the appropriate values to the record retrieval fields named D@<KeyFieldName> and D#END#<KeyFieldName>.
E@DBBEGRNG Move a number into E@DBBEGRNG in order to tell the interface which key is the last significant one defining the range. This number is equivalent to the position of the field in the index.

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.