On 7/3/2012 10:05 AM, Unsupported wrote:
// case 1: exception
//verify(sqlite3_prepare_v2(db, "create trigger updater update of result on
plugins"
// " begin"
// " update mails set kav=case old.result when 'infected' then ? else
0 end where uid=old.uid;"
// " end;"
// , -1, &stmt, 0) == SQLITE_OK);
//verify(sqlite3_bind_int(stmt, ++idx, -1) == SQLITE_OK);
You can't use parameters with DDL statements (all kinds of CREATE
SOMETHING, DROP SOMETHING et al). You can only parameterize DML
statements - SELECT, INSERT, UPDATE and DELETE.
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
