Hi, is there any documentation about error codes and SQLSTATE values available? I couldn't find any on the sqlite.org site or other somewhere else.
I need to programmatically detect the error condition "duplicate key" so that I can retry my work with a new key then. MySQL [1] and PostgreSQL [2] do support SQLSTATE values, but in a quite different way. (Wasn't SQL-92 supposed to make it compatible?) But a code beginning with "23" seems to be close enough. [1] http://dev.mysql.com/doc/refman/5.0/en/error-messages-server.html [2] http://www.postgresql.org/docs/8.2/interactive/errcodes-appendix.html -- Yves Goergen "LonelyPixel" <[EMAIL PROTECTED]> Visit my web laboratory at http://beta.unclassified.de ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
