On 14 Oct 2011, at 3:52am, [email protected] wrote:

> What I want to know is if there is any way to get more better
> reporting, such as the column or constraint it is upset about.  The
> message is not helpful.

Sorry, you can't get a better one.

> I have checked all the columns, all the
> values, and they are set up properly.  If there is no such more better
> reporting, ok, I will take other approaches.

Try doing a PRAGMA integrity_check.  I don't know that it does catch FOREIGN 
KEY errors, but it might.

> If you don't know the
> answer, you could either say so or say something useful or say nothing.

He's trying to be helpful and doesn't know that that answer doesn't help you.

Simon.
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to