Re: [sqlite] Backward cursor support?

2016-10-13 Thread Hick Gunter
016 18:49 An: SQLite mailing list <sqlite-users@mailinglists.sqlite.org> Betreff: Re: [sqlite] Backward cursor support? Keith, On Wed, Oct 12, 2016 at 12:01 AM, Keith Medcalf <kmedc...@dessus.com> wrote: > > No -- only navigable database support navigation (ie, hierarchical,

Re: [sqlite] Backward cursor support?

2016-10-12 Thread Keith Medcalf
014-05/what-i-learned-about-sqlite- > at-a-postgresql-conference > > > > > >> -Original Message- > >> From: sqlite-users [mailto:sqlite-users- > boun...@mailinglists.sqlite.org] > >> On Behalf Of Igor Korot > >> Sent: Tuesday, 11 Octo

Re: [sqlite] Backward cursor support?

2016-10-12 Thread Jens Alfke
> On Oct 12, 2016, at 9:49 AM, Igor Korot wrote: > > Forward cursors are supported by means of prepare()/step(), but what about > backward cursors? No, SQLite cursors only go in one direction, i.e. there is no step_back function. You could simulate this feature by copying

Re: [sqlite] Backward cursor support?

2016-10-12 Thread Simon Slavin
On 12 Oct 2016, at 5:49pm, Igor Korot wrote: > Forward cursors are supported by means of prepare()/step(), but what > about backward cursors? If you consider the use of prepare()/step() to be a forward cursor, then it supplies a backward cursor too. Just add "DESC" to the

Re: [sqlite] Backward cursor support?

2016-10-12 Thread Igor Korot
t >> Sent: Tuesday, 11 October, 2016 21:42 >> To: Discussion of SQLite Database; General Discussion of SQLite Database >> Subject: [sqlite] Backward cursor support? >> >> Hi, >> Does SQLite support backward cursor? Something like step_back()? >> >> If not,

Re: [sqlite] Backward cursor support?

2016-10-11 Thread Keith Medcalf
conference > -Original Message- > From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] > On Behalf Of Igor Korot > Sent: Tuesday, 11 October, 2016 21:42 > To: Discussion of SQLite Database; General Discussion of SQLite Database > Subject: [sqlite] Backward cur

[sqlite] Backward cursor support?

2016-10-11 Thread Igor Korot
Hi, Does SQLite support backward cursor? Something like step_back()? If not, what would be a way to do it? Thank you. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org