Igor Tandetnik wrote: > 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.
Hmm... I don't think this is incorrect per se, but where is this documented? I have not found any warning about this in prepare/bind/lang_expr/... documentation. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
