Retrieving error codes from SQLite when using ExecuteNonQuery()

Question

In my C# project, I'm using System.Data.SQLite.dll downloaded from CodeProject.

My problem is as per the title - how to get the error codes after calling SqliteCommand.ExecuteNonQuery() function?

Error codes such as SQLITE_CONSTRAINT, SQLITE_BUSY, SQLITE_LOCKED as shown here.

Buckjumper

Answer 1

use the Exception.StackTrace or the SQLiteException.ErrorCode

try
{

}
catch(SQLiteException ex)
{
    string code = ex.ErrorCode;
}

Strade

Answer 2

I'm going to add to this to help others, if you're developing in .NET. Use the

SQLiteErrorCode enumeration to test the result, cast the ErrorCode:

try
{

}
catch(SQLiteException ex)
{
    SQLiteErrorCode sqlLiteError= (SQLiteErrorCode)ex.ErrorCode;

    //Do whatever logic necessary based of the error type
}

Telega

Answer 3

Good question. System.Exception does not have a member by the name ".ErrorCode"

    Catch Ex As SQLiteException
        E = Ex.ResultCode
        Return E
    End Try

Kikuyu