在 Mon, 04 Apr 2005 19:03:59 +0800,Tim Anderson <[EMAIL PROTECTED]> 写
道:
-----Original Message-----
From: liigo [mailto:[EMAIL PROTECTED]
Sent: 04 April 2005 08:58
To: sqlite-users@sqlite.org
Subject: [sqlite] How to do: move to Next/Prev record?
When wrap sqlite to anothe language,
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. (?)