Cursors problem

Hello Everybody,

Is there a possbility to fetch previous records using cursors in Pro*c/c++.

I am writing a database interface which will give functions to fetch a set of records from a table , fetch the next or the previous set of records. Fethcing the next set of records using cursors is easy, but to fetch the previous set of records is difficult, because as I understand within a cursor fetch you cannot fetch the previous record.

There are to possibilities :
1)I open the cursor again fetch the records until I reach the point from which I get my previous set of records.

2)I fetch all the records into memory structures and then use these structures to get the next and previous set of records.

Both these solutions are not practical if we are looking at table with >1,00,000records with a record size of 500bytes.

Can anybody suggest a better solution.

Thanks in advance. Received on Tue Feb 25 1997 - 00:00:00 CST