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 in context:
http://www.nabbl
On Fri, 12 Jun 2009 07:05:36 -0700 (PDT), sql_newbie
wrote:
>
>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, &zErrMsg );
>
>How can i save
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, &zErrMsg );
How can i save the returned result-table in a C string for further use in
the program?
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, &zErrMsg );
Igor Tandetnik wrote:
>
>
> delete from urls
> where url not in ('url1', 'url2', ..., 'url20');
sql_newbie wrote:
> rc = sqlite3_exec( db, "DELETE FROM urls", NULL, NULL, &zErrMsg );
>
> The previous code will delete everything in the "urls" table and this
> is not what i want.
> I have a string Array "MyURLsArray" which contains 20 URLs as
> strings. My question is:
>
> How can i format the
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", &db );
if ( rc )
{
sqli
6 matches
Mail list logo