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