Finding the records bottom to top

shibily

Hi all,,
Anybody please tell me how to find the record from bottom to top. I have the last record by using the FIND('+') . I want to come one step backward .

How it is possible..


Thanks in advance

shibily

Belias

use

until myrec.next(-1) = 0

instead of

until myrec.next = 0

kine

Or you can use ASCENDING(false) to sort the data in descending order if possible and you can go through in normal way. Next(-1) is not good for SQL caching etc.

kriki

Remember that with ASCENDING(FALSE), you cannot use FINDSET. You need to use FIND('-')-NEXT.