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');
>
> Igor Tandetnik
>
>
>
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
>
--
View this message in context:
http://www.nabble.com/sql-query-with-sqlite3_exec-tp23988559p23991543.html
Sent from the SQLite mailing list archive at Nabble.com.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
