Re: [sqlite] CREATE TRIGGER IF NOT EXISTS throws error
I think you need 3.3.8 or greater. On Mon, 2007-03-26 at 07:39 +0200, stephan nies wrote: > I am using sqlite 3.3.5 . > > On 3/25/07, Eric Pankoke <[EMAIL PROTECTED]> wrote: > > > > What version of SQLite are you using? I'm not sure the IF EXISTS option > > was present until a certain version of 3.x (though I'm not sure which > > version). > > > > Eric Pankoke > > Founder > > Point Of Light Software > > 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 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 > > > > > > > > > > - > > To unsubscribe, send email to [EMAIL PROTECTED] > > > > - > > > > - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] CREATE TRIGGER IF NOT EXISTS throws error
I am using sqlite 3.3.5 . On 3/25/07, Eric Pankoke <[EMAIL PROTECTED]> wrote: What version of SQLite are you using? I'm not sure the IF EXISTS option was present until a certain version of 3.x (though I'm not sure which version). Eric Pankoke Founder Point Of Light Software 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 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 - To unsubscribe, send email to [EMAIL PROTECTED] -
RE: [sqlite] CREATE TRIGGER IF NOT EXISTS throws error
What version of SQLite are you using? I'm not sure the IF EXISTS option was present until a certain version of 3.x (though I'm not sure which version). Eric Pankoke Founder Point Of Light Software 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 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 - To unsubscribe, send email to [EMAIL PROTECTED] -