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);
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
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
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":
4 matches
Mail list logo