Hi,

         
        I try to create a trigger with following statements
         
        Create Table TabTest (
         UID_DialogNotification char(38) NOT NULL,
         Sender char(38) NOT NULL,
         Primary Key (UID_DialogNotification)
          )
         
        Create Table DialogColumn (
         UID_DialogColumn char(38) NOT NULL COLLATE NOCASE,
         Primary Key (UID_DialogColumn)
          )

        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 Column TabTest.Sender is the problem. The parser has a problem with 
the keyword END in Sender. :-(
         
        But I cant't rename the columns.
        Any Idea, Bugfix or Workaround?
         
        I'm using SQLite Version 3.2.8.
         
        Thanks
        Sylko
         
         

Reply via email to