prvkey statement

The prvkey statement operates in the same manner as the nxtkey statement with the exception that the keys returned are those previous to the beginning key value key.


PRVKEY result FROM filevar,a.code,key,n THEN/ELSE


result Returned variable containing the keys retrieved in a multi-attribute dynamic array.
filevar Variable to which the data file has been opened.
a.code String expression containing the a (algebraic) processing code located in the file-defining item that identifies the index to use.

The index must have previously been created with create-index.

key Beginning key value at which to begin the retrieval.
n Number of keys to retrieve.


The keys are returned in what might be viewed as reverse order, and a short list is due to a beginning file condition.