Simon, thank you for your reply.
Unfortunately as a novice I’m still struggling to find a construct that will do
what I want.
Reading the on-line SQLite guide to the UPDATE statement:
“If the UPDATE statement does not have a WHERE clause, all rows in the table
are modified by the UPDATE.”
I was hoping that the command:
UPDATE folder
SET Folder_Path = 'E:\Photos'
would change the directory references in all existing 16 rows currently
containing Folder_Path references to the wrong locations to the correct
location ‘E:\Photos’ however this also generates a “UNIQUE constraint failed”
error.
I also downloaded the SQLite CLI tool and tried to execute the command
".schema" but received the error “unable to open database” when trying to open
the file. (The file opens without problems using the application ‘DB Browser
for SQLite’).
I have now managed to upload the file to my Google drive and it’s accessible
via the following link:
https://drive.google.com/open?id=191LBKrl7hA7OR2HUUFbFnU71lF9X9uoo
Examining ‘Table -> Folder’ shows the 16 rows containing the incorrect folder
paths all of which now need to point to ‘E:\Photos’
Kind regards,
Carlo.
________________________________
From: sqlite-users <[email protected]> on behalf of
Simon Slavin <[email protected]>
Sent: Thursday, December 6, 2018 9:22:35 PM
To: SQLite mailing list
Subject: Re: [sqlite] Updating Folder_Path in Windows 10 Photos App
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
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
