Hi there,
I'm trying to manage to have a RAISE inside a trigger bringing out a language-customized message, but without success. I have the problem that RAISE doesn't accept neither variable nor "select" statements as an argument, but only the construction RAISE(rollback, "this is the error message"). Here is the exact code that I'm trying to implement: CREATE TRIGGER bru_PERSONEN BEFORE UPDATE ON personen FOR EACH ROW BEGIN SELECT CASE WHEN (NEW.blz IS NOT NULL AND (SELECT blz FROM banken WHERE blz = NEW.blz) IS NULL) THEN RAISE(ABORT, select msg_text from messages where lang_code = 'DE' and msg_code = 'CMG-00001' ) END; END; And this fails, of course with: SQL error: near "select": syntax error. Is there any known workaround for this? I've checked also http://www.mail-archive.com/sqlite-users@sqlite.org/msg22533.html but it doesn't work for me. I have the version 3.6.13. Cheers, Dimce _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users