Igor Tandetnik wrote: > > "sqlite" <[EMAIL PROTECTED]> wrote > in message news:[EMAIL PROTECTED] >> We are using SQLite for our application development which would be >> deployed in a pocket pc.Here we are using a query which has three >> Inner joins and using sqlite3_prepare and sqilte3_step function to >> prepare the records and to fetch the records.By executeing the Query >> and we moves to certain records say up to 10 records,while going >> upwards how to move to the initial record without reexecuting the >> Query and preparing the rowset again, > > You can call sqlite3_reset, after which the next sqlite3_step would > restart from the first row. > > Igor Tandetnik > > Dear Igor > > Thanks for your reply, we already tried this method but by executing the > sqlite_reset function it will again prepare the rowset, which takes more > time for us to get the initial record, is there any other way to get the > initial record without reseting the rowset where takes less time to get > the initial record. > > Regards, > kartthi > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > >
-- View this message in context: http://www.nabble.com/Move-rowset-pointer-to-Initial-record-tp17509266p17511237.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
