Re: [sqlite] Executing SELECT and INSERT from C under Linux
Thank you, Simon. Erik On Mon, Apr 12, 2010 at 3:19 PM, Simon Davies <simon.james.dav...@googlemail.com> wrote: > On 12 April 2010 14:01, Erik Kvernstad <erik.kverns...@gmail.com> wrote: >> I am writing a C program under Linux to perform operations on an >> sqlite-created (manually) database. I have successfully compiled and >> linked with the sqlite3 library and my program opens and closes the Db >> successfully. >> However, it is unclear to me how I in a simple way may perform >> operations like SELECT, INSERT etc. on the database from the C >> program. >> >> Grateful for hints. > > second question in > http://www.sqlite.org/cvstrac/wiki?p=SqliteWikiFaq gives some suggestions > >> >> Erik Kvernstad > > Regards, > Simon > ___ > 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] Executing SELECT and INSERT from C under Linux
Thank you so much for this information. Erik On Mon, Apr 12, 2010 at 3:46 PM, Nick Shaw <nick.s...@citysync.co.uk> wrote: > I assume you're using the C API calls to open/close the database? If > so, it's just another API call to execute some simple SQL: > sqlite3_exec(). If you need something more advanced, like prepare, > bind, step etc, then see the appropriate APIs for those. All listed in > http://www.sqlite.org/c3ref/funclist.html. > > Thanks, > Nick. > > -Original Message- > From: sqlite-users-boun...@sqlite.org > [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Erik Kvernstad > Sent: 12 April 2010 14:02 > To: sqlite-users@sqlite.org > Subject: [sqlite] Executing SELECT and INSERT from C under Linux > > I am writing a C program under Linux to perform operations on an > sqlite-created (manually) database. I have successfully compiled and > linked with the sqlite3 library and my program opens and closes the Db > successfully. > However, it is unclear to me how I in a simple way may perform > operations like SELECT, INSERT etc. on the database from the C > program. > > Grateful for hints. > > Erik Kvernstad > ___ > 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 > ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Executing SELECT and INSERT from C under Linux
I am writing a C program under Linux to perform operations on an sqlite-created (manually) database. I have successfully compiled and linked with the sqlite3 library and my program opens and closes the Db successfully. However, it is unclear to me how I in a simple way may perform operations like SELECT, INSERT etc. on the database from the C program. Grateful for hints. Erik Kvernstad ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users