Great, that fits the bill perfectly, thanks!
I know you mentioned the code is incomplete but the usage instructions
don't match the executable's behavior: the third command line argument
(the SQL command, or argv[2]) isn't used by the code. The interactive mode
works great though, and demonstrates the prepare/step/finalize method
very clearly.
It would be cool if sqlite came with an examples/ subdirectory that
contained this program (or ones like it). Examples can often explain
things so much more easily than text descriptions of functions.
-- Al
On Tue, 27 Jul 2004 10:14:06 -0400, [EMAIL PROTECTED]
<[EMAIL PROTECTED]> wrote:
>
> On Mon, Jul 26, 2004 at 08:05:17PM -0700, Al Danial wrote:
> > Thanks for the clarification. I'll need to study the docs on the three
> > part method and slowly figure it out. A working example sure would
> > be nice! -- Al
> >
> > On Mon, 26 Jul 2004 11:21:08 +0100 (BST), Christian Smith
> > <[EMAIL PROTECTED]> wrote:
> > > Typed data retrieval is not supported by the callback method of execution.
> > >
> > > You must use the prepare/step/finalize execution method.
> > >
> > > Check out:
> > > http://www.sqlite.org/capi3.html
> > >
> > > in particular, the sqlite3_step and related functions in section 2.2
> > > "Executing SQL statements." This section gives the functions to retrieve
> > > typed data from a row.
>
> Are you looking for an example of just the 3 part method? I'm working on something
> here, which I think gives the jist of it. Still beta, since blob type isn't
> finished:
>
> http://souptonuts.sourceforge.net/code/apiSQLite3b.c.html
>
> Or, http://prdownloads.sourceforge.net/cpearls/sqlite_examples.tar.gz?download
> but look at example "apiSQLite3b.c".
>
> I'm not sure this is what you want, but maybe it will help.
>
> Regards,
>
> Mike Chirico
> [EMAIL PROTECTED]
>
