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

