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

2006-01-09 Thread Sylko Zschiedrich 
Thanks  and the solutionits 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]>

Re: [sqlite] CREATE TRIGGER - Parser Bug?!

2006-01-09 Thread drh 
"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]>

[sqlite] CREATE TRIGGER - Parser Bug?!

2006-01-09 Thread Sylko Zschiedrich 
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