Re: [sqlite] sql query with sqlite3_exec

Thanks very much. The link was very useful, and now it is clear to me how basiclly to use sqlite3 C++ API. =) Kees Nuyt wrote: > > On Fri, 12 Jun 2009 07:05:36 -0700 (PDT), sql_newbie > > > http://www.sqlite.org/cvstrac/wiki?p=SimpleCode > -- View this message

Re: [sqlite] sql query with sqlite3_exec

I have another question about sqlite3_exec : How can i interact with the database and save the result in a C string for forther use. For example: sqlite3_exec( db, "SELECT FROM urls", NULL, NULL, ); How can i save the returned result-table in a C string for further use in the program?

Re: [sqlite] sql query with sqlite3_exec

Thanks, with help of Friend of mine, we have made the following changes to your statement: rc = sqlite3_exec( db, "DELETE FROM urls where url not in (" + MyURLsArray + ")", NULL, NULL, ); Igor Tandetnik wrote: > > > delete from urls > where url not in ('url1', 'url2', ..., 'url20'); > >

[sqlite] sql query with sqlite3_exec

Hi, i am using sqlite3 with C++, and everything is ok. I have a situation and i do not know how to handle it : Let's say i have a database file named "MyDatabase", i am opening this database as follows: sqlite3 *db; int rc; rc = sqlite3_open( "C:\\MyDatabase", ); if ( rc ) {