Hello, when i build a test table with: CREATE TABLE test(a text);
and try to implement a trigger using: CREATE TRIGGER IF NOT EXISTS trig_name BEFORE INSERT ON test FOR EACH ROW BEGIN SELECT RAISE(ROLLBACK, 'blabla') WHERE NEW.a = 'pong'; END; I get this error message: SQL error: near "NOT": syntax error if i omit the "IF NOT EXISTS" everything woks fine. According to the Documentation at http://www.sqlite.org/lang_createtrigger.html SQLite should understand this syntax. So what am i doing wrong here? Thanks, Stephan