[sqlite] CREATE TRIGGER - Parser Bug?! --> Solution

[Sylko Zschiedrich]

Thanks  and the solution....its a SQLite.net Bug! :-(
 
Sylko

        -----Ursprüngliche Nachricht----- 
        Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
        Gesendet: Mo 09.01.2006 00:04 
        An: sqlite-users@sqlite.org 
        Cc: 
        Betreff: Re: [sqlite] CREATE TRIGGER - Parser Bug?!
        
        

        "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]>