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,
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
> 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
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
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,
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
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
7 matches
Mail list logo