It would be really nice if SQLite could include an index number of the part of the sql statement when an error occurs in a multi-part sql statement. For example, if I run the following as one query:
INSERT INTO X VALUES (1);
INSERT INTO Y VALUES (2);
INSERT INTO Z VALUES (3);
and let's say table Y doesn't exist so it errors out, it'd be nice if the error message included some indication of which part of the query caused the error.
Thanks,
Sam
We're hiring! B-Line Medical is seeking .NET Developers for exciting positions in medical product development in MD/DC. Work with a variety of technologies in a relaxed team environment. See ads on http://careerbuilder.com.