Re: Cursors problem

Michael Habarta,hsingh_at_minerva.mch.sni.de,CINet writes: <<
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.
>>

The cilink middleware already provides this functionnality. It provides the fpossibility to fetch next, previous, relative, absolute, first, * Moreover it provides your th epossibility to fetch severeal row at a time: for instance:

fetch absolute 5 mycursor for 10
will read 10 rows from the cursor called mycursor from the 5th row.

Try cilink from www.cornut.fr

--->> On our site a SHAREWARE SQL Query Tool <<------- --->> & a middleware much faster than SQL*Net <<-------

Frederic BOUQUET             Client/Server & SQL RDBMS
email: fbouquet@cornut.fr       http://www.cornut.fr/