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]