Re: [sqlite] can sqlite result be sorted by using "prepare-step" API

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Shaun Seckman (Firaxis) wrote: > This is a side question to the topic, but is it possible to generate the > prepared statement opcodes at compile-time and store them in some sort > of data file instead of running through the lexical parser? It seems >

Re: [sqlite] can sqlite result be sorted by using "prepare-step" API

This is a side question to the topic, but is it possible to generate the prepared statement opcodes at compile-time and store them in some sort of data file instead of running through the lexical parser? It seems like for embedded tightly controlled systems where the database schema will rarely ch

Re: [sqlite] PRAGMA integrity_check(integer)

Hi Simon, > > I have SQLite 2.x database and sometimes it takes a long time to run > > "integrity_check" on the database. > > How long ? Minutes ? Hours ? > > Simon. I have one database file which "pragma integrity_check" never comes back from. I am using "sqlitebrowser 1.1". -chang

[sqlite] can sqlite result be sorted by using "prepare-step" API

> I am currently involved in porting sqlite on mobile phone As an aside, you do realize that most smartphone OSes already have SQLite available? WinCE, iPhone OS, Symbian, PalmOS, Pre, and Android either have SQLite libs built-in to the SDK, or have a version of SQLite that compiles with

Re: [sqlite] Huge numbers of savepoints.

That's just what I was looking for. Thanks, Chris. On Aug 23, 4:36 pm, Doug Currie wrote: > On Aug 23, 2009, at 6:46 AM, Chris Dew wrote: > > > Note: this is not for production code, just an experiment in keeping a > > history of application 'state', allowing current state to be > > recalculate

Re: [sqlite] can sqlite result be sorted by using "prepare-step" API

On 24 Aug 2009, at 9:13am, nick huang wrote: > This is just the usual case when all query results are retrieved and > then sorted. What I am insterested in is if there is any method to > get the sorted rows by "step" as I am working on mobile phone system > where time-consumed operation wou

Re: [sqlite] sqlite-users Digest, Vol 20, Issue 63

> Message: 9 > Date: Sun, 23 Aug 2009 21:33:06 -0500 > From: "Jay A. Kreibich" > Subject: Re: [sqlite] can sqlite result be sorted by using > "prepare-step" API > To: General Discussion of SQLite Database > Message-ID: <20090824023306.gb1...@uiuc.edu> > Content-Type: text/plain; charset=us-ascii

Re: [sqlite] can sqlite result be sorted by using "prepare-step" API

hi, Thanks for your reply. > nick huang wrote: > > For example, query statement is something like "select * from > > sometable order by somefield;" and we call prepare followed by step. > > And are all results returned from "step" in order of "somefield"? > > Of course. What would be the