-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
>
...@sqlite.org] On Behalf Of Jay A. Kreibich
Sent: Monday, August 24, 2009 10:28 AM
To: General Discussion of SQLite Database
Subject: [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 real
> 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
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
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
On Mon, Aug 24, 2009 at 01:55:41AM +, nick huang scratched on the wall:
>
> I am a kind of new to Sqlite and just wonder if the query result row
> could be sorted by using Sqlite_prepare followed by Sqlite_Step.
Prepare/step is the only way to get data out of the database, so yes.
> For ex
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 point of specifying "order by somefield"
otherw
hi all,
I am a kind of new to Sqlite and just wonder if the query result row could be
sorted by using Sqlite_prepare followed by Sqlite_Step.
For example, query statement is something like "select * from sometable order
by somefield;" and we call prepare followed by step. And are all result
8 matches
Mail list logo
