Sylko Zschiedrich wrote:
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;

Not answering your question, but note that the condition may also, perhaps more clearly, be expressed as follows:

SELECT RAISE(FAIL, 'Error')
WHERE not exists (SELECT * FROM DialogColumn WHERE UID_DialogColumn = new.Sender);

Igor Tandetnik

Reply via email to