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

Reply via email to