-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
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?
Note that in the past for constraint expression errors you were only told
that a constraint had failed and not which one. That was really hard to
work with.
Roger
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)
iEYEARECAAYFAlA5lEsACgkQmOOfHg372QRlOwCg1L3trwvSsyRdehyXaYRwzIkq
v4MAn3Gd7K2a/UhQ5uNHC8wrb4NmhXnu
=J1Iw
-----END PGP SIGNATURE-----
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
