[sqlite] Concurrency violation: the UpdateCommand affected 0 of the expected 1 records

[Agrawal, Manish]

Hello

I am getting this error when trying to update a database row in a C# 
application. The data set ds has been created using the standard Visual Studio/ 
System.Data.SQLite tools.

The table definition is:

CREATE TABLE "Test" (
        "test_Id" INTEGER PRIMARY KEY  AUTOINCREMENT  NOT NULL  UNIQUE , 
        "Points" INTEGER NOT NULL,  
        "File_Location" VARCHAR NOT NULL 
)

The C# code is:

int rowNumber = tBox.rowNumber;         // TextBox
ds.Test[rowNumber].Points = (int)points;        // from tbox
testAdapter.Update(ds.Test[rowNumber]); // ERROR THROWN HERE

Any help in resolving would be greatly appreciated.

Using Visual Studio ultimate 2010 and sqlite-1.0.79

Thanks
Manish
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users