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