On 6 Dec 2018, at 9:01pm, Carlo capaldo <carlocapa...@hotmail.com> wrote:
> UNIQUE constraint failed: Folder.Folder_Path: You seem to have two rows in the table: one with the correct Folder_Path and one with the incorrect Folder_Path. So instead of an UPDATE you just need a DELETE command like DELETE FROM folder WHERE Folder_Path = 'C:\Users\carlo\Pictures' AND folder_Id = 1 However, please check by eye to make sure I've understood the situation correctly, before you execute the above DELETE command. If it's not obvious whether this is the right thing to do, then using the SQLite CLI tool, execute the command ".schema" and paste the resulting text into a reply to this thread. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users