On 26 Aug 2012, at 4:13am, Roger Binns <[email protected]> wrote:
> On 25/08/12 13:04, John Taylor wrote:
>> insert into tbl values("john");
>
> You should use single quotes for string literals in SQL not double quotes.
>
>> Error: near line 9: column name is not unique
>
> It does tell you the name of the column. Under what circumstances could
> you not work with that?
You know, it does make sense that if the problem is a violated constraint, it
does always tell you which constraint was violated. You might have a number of
different constraints on a column, and it would be nice to be told which one
was causing the abort.
Simon.
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
