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
