On 9 Jan 2011, at 2:48pm, BareFeetWare wrote: >> 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?
On 10/01/2011, at 3:01 AM, Simon Slavin wrote: > http://www.sqlite.org/c3ref/errcode.html > > I'm guessing your 'constraint failed' is just the numeric result 19. Using > sqlite3_errmsg() or sqlite3_errmsg16() should get you the long text version. No. sqlite3_errmsg() is what I'm using, which is giving me the string "constraint failed". Where does the sqlite3 command line tool get the more descriptive error? 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
