"Sylko Zschiedrich" <[EMAIL PROTECTED]> wrote: > > I try to create a trigger with following statements > > create trigger tU_TabTest > after Update on TabTest > FOR EACH ROW > begin > SELECT RAISE(FAIL, 'Error') > WHERE (SELECT 1 FROM DialogColumn > WHERE UID_DialogColumn = new.Sender) IS NULL; > END; > > The create trigger statement failed with: near "NULL": syntax error > > The parser has a problem with the keyword END in Sender. :-( >
I can feed the statements in your email into the precompiled sqlite shell program on the website and they work just fine. I'm guessing there is a bug somewhere else in your system. You might also want to have a look at the sqlite3_complete() API if you were not already aware of it. -- D. Richard Hipp <[EMAIL PROTECTED]>
