> -----Original Message----- > From: liigo [mailto:[EMAIL PROTECTED] > Sent: 04 April 2005 12:52 > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] How to do: move to Next/Prev record?
> > Not sure exactly what you mean here. The Sqlite API lets you step > > forward through a result set, but not back. I'm not sure how other > > wrappers do it, but in my simple Delphi wrapper > > (http://www.itwriting.com/sqlitesimple.php) I copy the data into an > > array (actually a TList) so that you can step back and forward. > > There's a trade-off between convenience and efficiency. > > > > Tim > > > this a a way, but maybe not the best one. > > when the result set is very large, it will cost a very large > memery. (?) That's true, though well-designed queries won't normally retrieve large result-sets. You can use the LIMIT and OFFSET clauses in SELECT to grab large result-sets in chunks. Tim