Re: [sqlite] CREATE TRIGGER IF NOT EXISTS throws error

2007-03-25 Thread Dan Kennedy
nies [mailto:[EMAIL PROTECTED] > > Sent: Sunday, March 25, 2007 1:47 PM > > To: sqlite-users@sqlite.org > > Subject: [sqlite] CREATE TRIGGER IF NOT EXISTS throws error > > > > Hello, > > when i build a test table with: > > > > CREATE TABLE test(a text);

Re: [sqlite] CREATE TRIGGER IF NOT EXISTS throws error

2007-03-25 Thread stephan nies
e http://www.polsoftware.com/ -Original Message- From: stephan nies [mailto:[EMAIL PROTECTED] Sent: Sunday, March 25, 2007 1:47 PM To: sqlite-users@sqlite.org Subject: [sqlite] CREATE TRIGGER IF NOT EXISTS throws error Hello, when i build a test table with: CREATE TABLE test(a text); and try to imp

RE: [sqlite] CREATE TRIGGER IF NOT EXISTS throws error

2007-03-25 Thread Eric Pankoke
PROTECTED] Sent: Sunday, March 25, 2007 1:47 PM To: sqlite-users@sqlite.org Subject: [sqlite] CREATE TRIGGER IF NOT EXISTS throws error 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

[sqlite] CREATE TRIGGER IF NOT EXISTS throws error

2007-03-25 Thread stephan nies
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":