On 6 Dec 2018, at 9:01pm, Carlo capaldo <[email protected]> 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
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
