SQLite4Unity3d icon indicating copy to clipboard operation
SQLite4Unity3d copied to clipboard

NotSupportedException: Cannot update List`1: it has no PK

Open StevenDextrain opened this issue 2 years ago • 0 comments

Hello guys, I need your help, I'm using SQLite4Unity3d on Unity, and I have this error : NotSupportedException: Cannot update List`1: it has no PK The line giving this error is :

var updateQuery = DatabaseManager.database.Query<Device>("UPDATE Device SET lastCalibration = ? WHERE Id = ?", DateTime.Now, currentDevice.Id);
DatabaseManager.database.Update(updateQuery);

currentDevice.Id is a simple int, in this instance, it's 1. For some reason, the update works (updates my DB correctly), but causes issues with my application so I can't keep it like that. I've already checked multiple times, the table HAS a primary key (Id), it is correctly initialized in my class, and I don't know where this issue could come from. I've looked around the internet and didn't find a solution that worked for me, so I'm contacting you as a last resort. Thanks in advance for your answers, let me know if you need more information, have a great day !

StevenDextrain avatar Oct 02 '23 10:10 StevenDextrain