Re: [sqlite] writting a text file from sqlite db in C
On Fri, 20 Mar 2009 08:12:28 -0400 (EDT), mrobi...@cs.fiu.edu wrote: >Thanks for your help. > >I checked those sites, and I worked with sqlite3.exe using the command >line tool, no problems, however I can not find anywhere samples of how to >applied these commands in C. > >Thru trial and error, I can now use sqlite3_open(), sqlite3_close(), to >open and close databases as well sqlite3_exec() to create tables, fields, >indexes, and insert data into the tables. I am stuck trying to do a >"select" and process the data in the tables. > >Please help!!! Did you have a look at: http://www.sqlite.org/cvstrac/fileview?f=sqlite/src/shell.c=1.207 ? For example, check the callback() function. >Michael > > > > >> On Thu, 12 Mar 2009 19:06:52 -0400 (EDT), >> mrobi...@cs.fiu.edu wrote: >> >>>Hi everybody, >>> >>>I would like to find the exact code in C to >>>output to a text file, data from a sqlite db in "C" >> >> Try the source for the sqlite command line tool. >> >>>Also, is there a place to find C sample code for Sqlite? >> >> Apart from the sqlite command line tool, I can recommend >> the source of fossil, which does all its magic around a >> SQLite database: >> http://www.fossil-scm.org/index.html/doc/tip/www/index.wiki >> >> Also, there is some code in the SQLite wiki: >> http://www.sqlite.org/cvstrac/wiki?p=SampleCode >> >>>Thank you very much >>> >>>Michael >> >> -- >> ( Kees Nuyt >> ) >> c[_] >> ___ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> > > >___ >sqlite-users mailing list >sqlite-users@sqlite.org >http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- ( Kees Nuyt ) c[_] ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] writting a text file from sqlite db in C
Thanks for your help. I checked those sites, and I worked with sqlite3.exe using the command line tool, no problems, however I can not find anywhere samples of how to applied these commands in C. Thru trial and error, I can now use sqlite3_open(), sqlite3_close(), to open and close databases as well sqlite3_exec() to create tables, fields, indexes, and insert data into the tables. I am stuck trying to do a "select" and process the data in the tables. Please help!!! Michael > On Thu, 12 Mar 2009 19:06:52 -0400 (EDT), > mrobi...@cs.fiu.edu wrote: > >>Hi everybody, >> >>I would like to find the exact code in C to >>output to a text file, data from a sqlite db in "C" > > Try the source for the sqlite command line tool. > >>Also, is there a place to find C sample code for Sqlite? > > Apart from the sqlite command line tool, I can recommend > the source of fossil, which does all its magic around a > SQLite database: > http://www.fossil-scm.org/index.html/doc/tip/www/index.wiki > > Also, there is some code in the SQLite wiki: > http://www.sqlite.org/cvstrac/wiki?p=SampleCode > >>Thank you very much >> >>Michael > > -- > ( Kees Nuyt > ) > c[_] > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] writting a text file from sqlite db in C
On Thu, 12 Mar 2009 19:06:52 -0400 (EDT), mrobi...@cs.fiu.edu wrote: >Hi everybody, > >I would like to find the exact code in C to >output to a text file, data from a sqlite db in "C" Try the source for the sqlite command line tool. >Also, is there a place to find C sample code for Sqlite? Apart from the sqlite command line tool, I can recommend the source of fossil, which does all its magic around a SQLite database: http://www.fossil-scm.org/index.html/doc/tip/www/index.wiki Also, there is some code in the SQLite wiki: http://www.sqlite.org/cvstrac/wiki?p=SampleCode >Thank you very much > >Michael -- ( Kees Nuyt ) c[_] ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users