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.

JohnnBlade · Accepted Answer · 2014-12-19 15:25:13Z

4

use the Exception.StackTrace or the SQLiteException.ErrorCode

try
{

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

edited Dec 19, 2014 at 15:25

answered Jun 27, 2012 at 9:45

JohnnBlade

4,3021 gold badge23 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Matt Drouillard · Accepted Answer · 2019-03-26 14:02:35Z

1

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
}

answered Mar 26, 2019 at 14:02

Matt Drouillard

3093 silver badges12 bronze badges

Comments

LewTwo · Accepted Answer · 2013-10-26 03:57:02Z

0

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

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

answered Oct 26, 2013 at 3:57

LewTwo

938 bronze badges

Collectives™ on Stack Overflow

Retrieving error codes from SQLite when using ExecuteNonQuery()

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related