I'm getting my information about RAISE from <http://www.sqlite.org/lang_createtrigger.html>
and an example from <http://www.sqlite.org/cvstrac/wiki?p=ForeignKeyTriggers> To my surprise, error-message is not defined in <http://www.sqlite.org/syntaxdiagrams.html#error-message> which should probably be rectified. The examples for the error text I've found are all simple text strings, for instance RAISE(ROLLBACK, 'delete on table "foo" violates foreign key constraint "fk_foo_id"') What I want to do is more like RAISE(ROLLBACK, 'Attempt to delete author '||old.name||' who has books.') but that doesn't work. And since RAISE(ROLLBACK, old.id) doesn't work I assume you can't use functions of any kind. Which is a pity, because I would like to have SQL generate an error message with context. Can this not be done with the current version ? And if not, rather than documenting the current behaviour, can error-message be made to be an expression in the next version ? Simon. -- http://www.hearsay.demon.co.uk | I'd expect if a computer was involved | it all would have been much worse. No Buffy for you. | -- John "West" McKenna Leave quickly now. -- Anya | THE FRENCH WAS THERE _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
