在 Mon, 04 Apr 2005 21:11:44 +0800，Tim_Anderson <[EMAIL PROTECTED]> 写
道:
-----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
You are right, thanks again!
