In triggers I often want to include information when raising an error. However, RAISE doesn't accept dynamic/derived arguments which would otherwise be valid in a SELECT.
SELECT RAISE(ABORT, 'string1' || 'string2');
-- Error: near "'string1'": syntax error
Does anyone know of a work-around?
--
Mark Lawrence
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
