Hi Dennis, On Tue, 24 Mar 2009 18:23:23 -0600, Dennis Cote <[email protected]> wrote:
>vinod1 wrote: >> I am new to sqlite and C. >> >> I have not been able to write a code which would read row by row using >> sqlite3_step. >> >> Could anybody guide me please. >> >Hi, > >This code is equivalent to the very old callback style code shown at >http://www.sqlite.org/quickstart.html. > >It should provide the same results using the newer prepare/step/finalize >set of calls that are discussed at http://www.sqlite.org/cintro.html. > >Hopefully it provides a complete, if somewhat basic, intro to the use of >the preferred C API functions. > >#include <stdio.h> >#include <sqlite3.h> [snip] > return rc!=SQLITE_DONE; >} > >HTH >Dennis Cote This seems a very nice addition to the http://www.sqlite.org/cvstrac/wiki?p=SampleCode we already have. I feel tempted to put it in the wiki http://www.sqlite.org/cvstrac/wiki under the 'Hints For Using SQLite More Effectively' heading, as http://www.sqlite.org/cvstrac/wiki?p=SimpleCode. Would you mind if I do? -- ( Kees Nuyt ) c[_] _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
