> From: itandet...@mvps.org
> Date: Wed, 16 Dec 2009 21:00:43 -0500
> Subject: Re: [sqlite] a possible bug of select min(id) from...
>
> nick huang wrote:
> > Say a table named "url" is created with "id" as primary key. Then a
> > query like this &
uot;This amalgamation was generated on 2009-08-10 13:49:19 UTC."
In sqlite3.h, there is a line @(#) $Id: sqlite.h.in,v 1.462 2009/08/06 17:40:46
drh Exp $
Some other details as following:
Open DB with sqlite3_open.
Open table with sqlite3_prepare/sqlite3_step
Best regards,
N
>
> > 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 compi
.edu>
> Content-Type: text/plain; charset=us-ascii
hi Jay,
>
> 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 followe
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 &
t;exec", "getTable" etc.
retrieve dataset and sort by themselves after they call "prepare-step".
Anybody has any idea about this?
Nick Huang/Qingzhe Huang
_
Stay in the
6 matches
Mail list logo