On 15 Jun 2009, at 2:37am, Simon Slavin wrote: > 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.
No responses to this ? Can someone confirm for me that error messages from 'RAISE' have to be just pre-assigned text strings and can't be expressions ? Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
