Re: [sqlite] Any way to get more information than "constraint failed" when a constraint fails?

2008-04-08 Thread Samuel Neff 
Roger,

Thanks for the link.  Still no indication of status though.. is this
something that may get improved in a future update of sqlite?

I updated the ticket I reported to include a link to the older existing
ticket.

Best regards,

Sam



On Tue, Apr 8, 2008 at 6:16 PM, Roger Binns <[EMAIL PROTECTED]> wrote:

>
>
> Samuel Neff wrote:
> > I first reported this when I started working with SQLite.
> >
> > http://www.sqlite.org/cvstrac/tktview?tn=2258
>
> There was an earlier ticket with more details about why this happens:
>
>  http://www.sqlite.org/cvstrac/tktview?tn=1648
>
> Roger


-
We're Hiring! Seeking passionate Flex, C#, or C++ (RTSP, H264) developer.
Position is in the Washington D.C. metro area. Contact
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Any way to get more information than "constraint failed" when a constraint fails?

2008-04-08 Thread Roger Binns 
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Samuel Neff wrote:
> I first reported this when I started working with SQLite.
> 
> http://www.sqlite.org/cvstrac/tktview?tn=2258

There was an earlier ticket with more details about why this happens:

  http://www.sqlite.org/cvstrac/tktview?tn=1648

Roger
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFH++7DmOOfHg372QQRAlDHAKC9nDiTOYuXxS4px+8a2ncwUHxcwwCg15cJ
q6Cb4elMqkTuwqig4M7MpUY=
=Oozg
-END PGP SIGNATURE-
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Any way to get more information than "constraint failed" when a constraint fails?

2008-04-04 Thread Samuel Neff 
Is there any way to get more information from SQLite when a constraint
fails, particularly which field caused the constraint to fail?

Ideally the error message should list the field name that caused the
constraint to fail, the bad value, and even the constraint itself.


This is what I get...

Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\>sqlite3
SQLite version 3.5.7
Enter ".help" for instructions
sqlite> create table t(a int check(typeof(a) = 'int'));
sqlite> insert into t values ('1');
SQL error: constraint failed
sqlite>


This is what would be nice

Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\>sqlite3
SQLite version 3.5.7
Enter ".help" for instructions
sqlite> create table t(a int check(typeof(a) = 'int'));
sqlite> insert into t values ('1');
SQL error: constraint failed: text value '1' failed to pass constraint
(typeof(a) = 'int')
sqlite>


I first reported this when I started working with SQLite.

http://www.sqlite.org/cvstrac/tktview?tn=2258

Thanks,

Sam

-- 
-
We're Hiring! Seeking passionate Flex, C#, or C++ (RTSP, H264) developer.
Position is in the Washington D.C. metro area. Contact
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users