Hi all,
I am trying to get as much detail on SQL errors generated by SQLite as possible.
Here's a test:
begin immediate;
create table "Names" (First, Last, unique(First, Last));
insert into "Names" values ('Mickey', 'Mouse');
insert into "Names" values ('Mickey', 'Mouse');
rollback;
When I run this via C, using sqlite3_errmsg(), I get the error message:
> constraint failed
but when I run it via the sqlite3 command line I get a more descriptive:
> SQL error: columns First, Last are not unique
How can I get the more descriptive error via sqlite3_*() routines?
Thanks,
Tom
BareFeetWare
--
Comparison of SQLite GUI tools:
http://www.barefeetware.com/sqlite/compare/?ml
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
