Hi Simon, Actually, I do get the CHECK constraint name returned to me in the error message otherwise, as you say, it would be impossible to find out what failed.
I use a translation table in my application to reformat the SQLite error message to a more suitable format to present to my users based on the constraint name. On Wed, Oct 8, 2014 at 9:00 AM, <sqlite-users-requ...@sqlite.org> wrote: > For most ways in which SQLite can refuse to do something, you have no way > to know why it refused. The results don't include the name of a constraint > which failed, or anything else of any use. You simply get a result code > which tells you that the operation failed because of the data in your > command (rather than because the command had bad syntax or referred to a > table/index/column which didn't exist). Pete lcSQL Software <http://www.lcsql.com> Home of SQLiteAdmin <http://www.lcsql.com/sqliteadmin.html> _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
