Is there any way to access data of the previous record in a select statement other than storing required values in variables ? Thanks.

Refer to - http://www.baanboard.com/baanboard/showthread.php?s=&threadid=13209

or use DESC in the order clause.

Just curious, Why you don't want storing method?

-Suhas

Thanks for the reply. I saw the link but that is not what i meant. See,my function is similar to the following -
When i am accessing the 10th record in a selectdo,i need some values from the 9th record. I was trying with rcd but it does not seem to store all the values of the record. Else i just have to store the values of the fields in some temp variables and access these when i go the next record. I was looking for something like a prev.xyz .