On 8 May 2014, at 10:40am, Constantine Yannakopoulos <alfasud...@gmail.com> wrote:
> On Thu, May 8, 2014 at 11:50 AM, Simon Slavin <slav...@bigfraud.org> wrote: > >> That's your job. You're the programmer. SQLite does not talk to users >> and its result values should never be shown to a user. > > Fair enough, but SQLite needs to give me what I need to be able to > communicate something helpful to the user. A generic error code and a > "Foreign key constraint failed" error message without any means of getting > some context is not very helpful. It's a fair point. Perhaps a future version of sqlite3_extended_result_codes() can return a string as well as the code, the string being the name of the constraint that was violated. However my understanding is that including this in SQLite3 would be difficult since its way of figuring out whether there's a constraint violation is limited. Which is why I suspect this will be in SQLite4, not SQLite3. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
